home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
CICA 1994 April
/
CICA Shareware for Windows CD-ROM (Walnut Creek CD-ROM)(April 1994).ISO
/
win3
/
access
/
access_l.exe
/
ACC9308.TXT
< prev
next >
Wrap
Text File
|
1994-01-07
|
244KB
|
5,438 lines
=========================================================================
Date: Sun, 1 Aug 1993 15:53:16 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Richard Brown (dickb)" <dickb@MICROSOFT.COM>
Subject: Re: Microsoft and the Internet
Nathan,
In case this hasn't been cleared up:
It's ACCBUG -- no hyphen.
By the way, in a previous career I worked as a newspaper
reporter. My first job was in Logansport. I used to drive
over to Purdue to hang around the campus and feel like
I was in a real city.
Dick Brown
Access Editing Manager
----------
From: Nathan Brindle <netmail!NBRINDLE@INDYCMS.BITNET>
To: Multiple recipients of list ACCESS-L <ACCESS-L@INDYCMS.BITNET>
Subject: Microsoft and the Internet
Date: Tuesday, July 27, 1993 9:05AM
This was posted some time back, but not everyone may have a copy or
remember it (I know <I> didn't...).
To report bugs in Access: Send mail to ACCBUG@MICROSOFT.COM
To send in your wishes for upcoming versions: ACC-WISH@MICROSOFT.COM
One caveat--I think I remember the ACCBUG address as ACC-BUG (with
the hyphen) but I didn't see it that way in the list archives. So if
ACCBUG doesn't work, try ACC-BUG. Or maybe someone has a hard copy
of Microsoft's letter that announced this handy?
BTW, as I told Phil Paxton, I agree with him that the record counting
problem is unlikely to be a bug. Since Access does not provide an implicit
recordcounting function, you're flirting with disaster :) when you try
to write one in Access Basic. "That's not a bug--it's a <feature>!"
What <does> interest me, however, is the fact that in Professional Basic
7.1 you can query an ISAM file via the LOF() function and get the number
of records returned to you. Why can't we do that in Access? Or am I
completely confused? (Which would NOT surprise me...)
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Sun, 1 Aug 1993 21:09:32 -0400
Reply-To: Eugene Levine <elevine@world.std.com>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Eugene Levine <elevine@WORLD.STD.COM>
Subject: Re: Microsoft and the Internet
In-Reply-To: <199308012256.AA03943@world.std.com>
Does anyone know how the Microsoft email address system works? I have some
questions/ requests/ suggestions about non Access applications, and about
he interface between them and Access.
Thanks in advance,
Gene
elevine@world.std.com
=========================================================================
Date: Mon, 2 Aug 1993 07:14:27 +0000
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Marty McMahon <Marty.McMahon@KAUAI.DS.BOEING.COM>
Subject: GRAPHS IN ACCESS
To: <ACCESS-L@INDYCMS.BITNET>
I'm relatively new to the use of ACCESS. Is there a good book that explains
how to build and modify graphs using ACCESS? Does it make more sense to
export to Excel and make them there?
marty.mcmahon@kauai.ds.boeing.com
=========================================================================
Date: Mon, 2 Aug 1993 10:29:00 LCL
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: MKRO <MKRO.DIS-PC@BMAILIN.ITG.TI.COM>
Subject: Text Box Input Editing As Data is Entered
Would like to know if anyone has a thought/created a way to edit or format
the input(value) of a text
box as it is being entered by a user? I have a text box that is bound to a
date field on a table. I would
like to be able to format the text in the text box as it is entered, so that
the user would see a "/" as they
type a date value. EXAMPLE: User types 01 then a "/" is shown
automatically by my logic User continues to type 05 then another "/" appears
in the text box and then the User completes the date entry with 93.
What this amounts to is dynamic data editting or formating. Is there a way
to do this with the format property? Or can it be accomplished in a
function()? Any suggestions or ideas?
Thanks in advance.
Mike Kroeger
=========================================================================
Date: Mon, 2 Aug 1993 16:37:00 GMT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: CHEN <CHEN%DIALOGVM@MCIMAIL.COM>
Hi all,
I'm trying to format a report printout to page break only at the
end of a record. Is there a way to do this? Will I need to write
a macro or module?
Thanks advance for your help!
Susan Chen
Dialog Information Services, Inc.
CDROM Division
chen@dialogvm.mcimail
=========================================================================
Date: Mon, 2 Aug 1993 12:03:29 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Louis M. Swiczewicz" <SWICZ@ACC.RWU.EDU>
Subject: Soccer Roster via Report Wizard
Dear Access-L members:
I have the responsibility for managing my town's youth soccer
league. To date, there are 32 teams distributed across four age
divisions. Each team has two coaches and at least 12 players.
The information for coaches is included in a table named
"Coaches Fall'93." The data for players is located in a table
named "House League F'93." The common link between these two
tables is the field entitled "Team ID."
I am attempting to generate a report (i.e., Roster) for each
team. I would like the names of the coaches to appear at the top
of the report and the players' information to appear in the body
of the report. I know that it is possible to create a report which
contains subreports using report wizard. However, my attempts to
incorporate subreports has not been very successful. Instead of
getting individual team rosters, the output is one report which
groups all players and coaches.
Does anyone know if it is possible to design a report using
report wizard that will give me 32 individual reports (rosters)
which will include the names for both players and coaches by team?
I have just recently started dabbling in Access basic so I am not
sure if the results I desire can be best achieved via that
methodology. I will appreciate all assistance. Thank you.
Lou Swiczewicz
Swicz@ACC.RWU.EDU
=========================================================================
Date: Mon, 2 Aug 1993 12:06:33 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Help on setting number of copies to print
Help! "I've got a little macro..." Well, the point is, I'm trying to
use an InputBox to get how many copies of a report the user wants to
print. It seems to work fine (including the Access Basic code) until
the value is input and the macro tries to use the value returned by
the function. The interesting part is that I get a BLANK error message
from Access when this point is reached (a message box with an exclamation
point but NO MESSAGE). So I don't see where the problem is.
Has anyone got a code example to show me how to do this? I'm scratching
my head, (not pulling out my hair--what hair?), wondering.
Thanks,
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Mon, 2 Aug 1993 13:58:10 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: copies to print--figured a dodge
I figured out how to specify the number of copies of the report I wanted.
I just wrote it in Access Basic and forgot the macro (except to call
the function). This procedure feels kludgy to me and it seems like it
would be nice if the OpenReport method in immediate print mode had a
number of copies argument. Of course, that might make calling the other
modes kind of weird.
The code fragment:
Function QLCopies()
Response = InputBox("How many copies to print?", "QuickList", "1")
If Response = "" then Exit Function
DoCmd SelectObject A_REPORT, "QuickList", True
DoCmd Print , , , , Response
DoCmd Minimize
QLCopies = Response
End Function
That's probably a mess (and QLCopies() is a dummy function anyway), but
for this particular program the Database window is minimized--thus the
DoCmd Minimize at the end to put it back where it belongs.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Mon, 2 Aug 1993 11:25:43 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Dmitry Serebrennikov <dmitry@UCSEE.BERKELEY.EDU>
Subject: Re: Text Box Data Editing as Data is Entered
>
> Would like to know if anyone has a thought/created a way to edit or format
> the input(value) of a text
> box as it is being entered by a user? I have a text box that is bound to a
> date field on a table. I would
> like to be able to format the text in the text box as it is entered, so that
> the user would see a "/" as they
> type a date value. EXAMPLE: User types 01 then a "/" is shown
> automatically by my logic User continues to type 05 then another "/" appears
> in the text box and then the User completes the date entry with 93.
>
> What this amounts to is dynamic data editting or formating. Is there a way
> to do this with the format property? Or can it be accomplished in a
> function()? Any suggestions or ideas?
>
> Thanks in advance.
> Mike Kroeger
>
According to MicroSoft there is no way to do this that in Access now.
The only alternative is to use AfterUpdate function to read the value
and reformat it to your liking and then put it back in the control.
It works, but only after user has left the field, not while typing.
There are talks about allowing to use VBX controls in Access and other
MS apps, but that is all not in the near future.
=========================================================================
Date: Mon, 2 Aug 1993 11:06:48 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Dmitry Serebrennikov <dmitry@UCSEE.BERKELEY.EDU>
Subject: Re: Access Basic
In-Reply-To: <199307301603.AA25681@hp4at.eunet.co.at> from "Dave Stultz" at
Jul 30, 93 09:02:38 am
I think this is mostely right, but:
> Function MoreButton()
> Docmd Hourglass True
> Docmd Echo False
> Docmd Setwarnings False
*******************
> Dim Curr as Form
> Dim F as String
> Set Curr=Screen.Activeform.Name
> Set F=Forms![Curr]
*******************
The piece in *** is the problem. The correct thing to use in the expressions
below in place of F is a variable of type Form. So if you have
Dim F as Form
Set F=Screen.ActiveForm
it should do the trick. Notice that it is just "Screen.ActiveForm" that
returns the current form Object. Screen.ActiveForm.FormName returns the name
of the form (a string). You could use that to get a hold of the form Object,
but it is a round-about way of doing it.
Also, as other people have mentioned you have to reset Echo to On in Access
Basic code manualy while in macros that is done for you when the macro ends.
Also you can not hide of disable a control that has the focus. But you knew
that didn't you...
> F!Titles.Visible=False
> F!Titles.Enabled=False
> F!Moretitles.Visible=True
> F!Moretitles.Enabled=True
> F!More.Visible=False
> F!More.Enabled=False
>
Good luck. Dmitry.
dmitry@ucsee.berkeley.edu
=========================================================================
Date: Mon, 2 Aug 1993 21:50:14 CDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Richard Moldwin <rmoldwin@MIDWAY.UCHICAGO.EDU>
Has anybody tried the new Sheriden Data Controls for VB 3.0? There is a
fully functional spreadsheet control that seems to emulate the Access
Datasheet. There are also controls to fill in most of the missing
datacontrols in VB. If I only knew how to transport my access form designs
into VB! Has anybody written a utility to do this yet? Transporting code is
easy, but the forms are another story.:-)
--Rich Moldwin
=========================================================================
Date: Mon, 2 Aug 1993 23:50:00 LCL
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: RH <RH.DIS-PC@BMAILIN.ITG.TI.COM>
Subject: Memo Field Text Formatting
I have an application that requires more text formatting capability within a
MEMO field then than appears to be available with Access (i.e. CNTRL ENTER
and SPACE). Is there a third party add-in for Access which provides features
like variable margins, hanging indents, bullets, and multiple fonts for MEMO
fields?
I would prefer not to link or imbed objects from other apps like WORD just to
get the enhanced formatting.
Any ideas?
Thanks in advance,
Bob Hanschke
Texas Instruments, Inc.
Dallas, TX
=========================================================================
Date: Tue, 3 Aug 1993 08:17:37 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: STAUFFER_ERIC_B@LILLY.COM
Subject: signoff
From: STAUFFER ERIC B IVM1 1 RM66696
Subject: ACCESS-L@INDYCMS.BITNET
To: INTERNET ADDRESS BITN
=========================================================================
Date: Tue, 3 Aug 1993 12:19:39 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Shannon Burgin <##06@UTMARTN.BITNET>
Subject: Re: Access Speed?
In-Reply-To: In reply to your message of THU 22 JUL 1993 14:49:59 EDT
> > I have just recently purchased Access 1.0 (and have upgraded to 1.1), and I
> > have been having some problems with speed. I have a 386-DX/33 Mhz with 4 Me
> > of RAM, and in Windows I'm running a 6 Meg permanent swapdrive with 32-bit
> > access. I am trying to write a database for a baseball card collection, and
> > every single action I make takes at least a few seconds, if not longer. I
> > have attached buttons to macros which run queries, and when I run them, the
> > hourglass icon appears for up to thirty seconds. Is there anything I can do
> > to speed this harrowing process up?
> > Dave Stultz
> > STULTZ@DENISON.EDU
> >
> > p.s.
> > I don't have a math co-processor - could having one make that much of
> >a difference?
>
>
> Dave, the rule of thumb I've heard circulated the most (and endorsed by
> Microsoft) is adding 4Mg of memory
> to a 386 (that already has 4Mg -- for a total of 8M) will increase Access
> performance significantly more than
> migrating to a 486 that only has 4Mg.
>
>
> Phil Paxton
> Development Editor, eidetic, and 7-ball juggler
> SAMS/Prentice Hall Computer Publishing
> Carmel, Indiana
My 386 Model/70 only had 4 meg when I began using Access. I have since
added 8 meg more for reasons other than speeding up Access, but the
side benefit is a significant improvement to Access.
************************************************************************
* * *
* Shannon Burgin * University of Tennessee/Martin *
* Bitnet: ##06@UTMARTN.BITNET * Computer Center *
* Phone: 901-587-7890 * 102 Cooper Hall *
* Senior Systems Analyst * Martin, TN 38238 *
* VM/VSE/CICS/VSAM/DLI/SQLDS * *
************************************************************************
=========================================================================
Date: Tue, 3 Aug 1993 10:44:15 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Deleting records and warnings
I previously posted how I figured out how to use macros to delete the
record currently displayed on a form. Well, something funny happened. I
wasn't using SetWarnings to turn off the messages, because I happen to like
being asked if I'm sure or not. Works real great in the first form I did
this in. I went to implement this in another form I have, and lo and behold,
it doesn't give me a warning! It simply deletes the record. Well, I figured,
maybe the SetWarnings flag was off for some reason, so I included an
explicit SetWarnings Yes action in the macro, but it still won't warn me.
What might be different between the two forms or underlying queries to
cause the different results? Both forms are based on queries.
Any ideas?
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Wed, 4 Aug 1993 09:20:25 +0200
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "M. Ederveen" <MARTIN@HSEPM1.HSE.NL>
Subject: Ole object test
Hello all!
It could be I previously posted this, but I never saw any reactions and the
problem is still there:
When fine-tuning the application I made with Access the following
problem occurred:
I'm using a picture (OLE-object) of a persons' autograph in the database.
The picture is supposed to be scanned and Pasted into the form.
I created a custom menu bar with the Paste function added.
This works fine.
Only thing is: I'd like to protect the picture from being overwritten by
mistake. So I tried using the ISNULL function in the same macro that
activates the Paste function in the custom menu bar. This works but not
good: the check is made properly but then the Paste function cannot be
activated anymore. Also the field property of an OLE-object doesn't have
features like ON-ENTER and ON-UPDATE, so how can I do this?
Greetings,
Martin.
-------------------------------------------------------------------------------
| ing. Martin W. Ederveen | "In the future there will be real |
| Hogeschool Eindhoven | thinking machines. |
| Rachelsmolen 1 | Yes, but who's thoughts will they |
| 5612 MA Eindhoven | be thinking?" |
| tel. +31 (40) 605 262 | |
| MARTIN@HSEPM1.HSE.NL | Quotation from Dr.Who: The Curse |
| SURF017@KUB.NL | of Fenric |
-------------------------------------------------------------------------------
=========================================================================
Date: Thu, 5 Aug 1993 10:40:05 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Dmitry Serebrennikov <dmitry@UCSEE.BERKELEY.EDU>
Subject: Re: Ole object test
In-Reply-To: <199308040722.AA20813@hp4at.eunet.co.at> from "M. Ederveen" at
Aug 4, 93 09:20:25 am
>
> Hello all!
>
> It could be I previously posted this, but I never saw any reactions and the
> problem is still there:
>
> When fine-tuning the application I made with Access the following
> problem occurred:
>
> I'm using a picture (OLE-object) of a persons' autograph in the database.
> The picture is supposed to be scanned and Pasted into the form.
> I created a custom menu bar with the Paste function added.
> This works fine.
> Only thing is: I'd like to protect the picture from being overwritten by
> mistake. So I tried using the ISNULL function in the same macro that
> activates the Paste function in the custom menu bar. This works but not
> good: the check is made properly but then the Paste function cannot be
> activated anymore. Also the field property of an OLE-object doesn't have
> features like ON-ENTER and ON-UPDATE, so how can I do this?
>
> Greetings,
>
>
> Martin.
>
I am not sure I understand the problem... If you could be more specific on
how you are using ISNull and why doesn't it work the secod time? Did you
try to step through the macro? What happens? Does ISNull think that the
field is not null even though it is?..
As a Bubble-Gum (tm) solution you can keep another field around with a flag
weither the picture is posted or not...
=========================================================================
Date: Fri, 6 Aug 1993 09:50:27 MEZ
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Erich Neuwirth <A4422DAB@VM.UNIVIE.AC.AT>
Subject: Re: ACCESS-L Digest - 4 Aug 1993 to 5 Aug 1993
In-Reply-To: Message of Thu,
5 Aug 1993 23:00:04 -0500 from <LISTSERV@INDYCMS.IUPUI.EDU>
i just got my software upgrade for access (1.1)
there is an offer in ther for the documetation for $ 49.50
having the printed docs for 1.0,
is it worthwhilw buying the updated documentation?
any recommendations?
ERICH NEUWIRTH
BITNET (EARN): A4422DAB@AWIUNI11
INTERNET: a4422DAB@vm.univie.ac.at = 131.130.1.2
Institute for Statistics, Operations Research, and Computer Methods
UNIVERSITY OF VIENNA, UNIVERSITAETSSTR. 5/9, A-1010 VIENNA, AUSTRIA
TEL.: +43-1-40407-160 FAX: +43-1-40407-88
=========================================================================
Date: Fri, 6 Aug 1993 08:55:33 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: MJY0000 <MJY0@ECC.BITNET>
Subject: Erratic Screens
I'd like to find out if anybody else is experiencing this problem:
When I'm in Design mode (whether it's a Form, Query, Table, etc.)
I will sometimes experience my screen or parts of my screen changing
to a larger font and usually changing to Bold also. It doesn't
seem to affect what's actually in my Access DB because when I switch
over to a "Run mode" everything appears okay. I cannot figure out
the pattern, if there is one, or what is causing this. It is rather
erratic because sometimes if I just click on the screen it will go
back to how it should be. Very strange.
I have not changed video divers or anything like that. I was
experiencing this problem before I upgraded to Access 1.1 and was
sort of holding out hoping the upgrade would "fix" the problem.
Also I am only experiencing this problem with Access. I use other
Apps such as Quicken, MS Word and Micrografx Designer with no problem.
This doesn't appear to be a devastating problem. It is something I
can live with - its just very annoying.
If anybody else is experiencing a similar problem or if someone has
a suggestion, I'd appreciate hearing from you.
_\\|//_
0 0
--------------uuu---U---uuu-----------------------------------------
- Mike Yurche - Phone (410) 780-6589 -
- Computer Services - Fax (410) 574-2172 -
- Essex Community College - -
- Baltimore, MD 21237 - BITNET MJY0@ECC -
--------------------------------------------------------------------
Opportunities are never lost - they're simply found by someone else!
=========================================================================
Date: Fri, 6 Aug 1993 08:09:52 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Steve Bratten <GE0793@SIUCVMB.BITNET>
Subject: Messed up screens in Design Mode...
>I'd like to find out if anybody else is experiencing this problem:
>
>When I'm in Design mode (whether it's a Form, Query, Table, etc.)
>I will sometimes experience my screen or parts of my screen changing
>to a larger font and usually changing to Bold also. It doesn't
I have experienced this on several occasions but, just as the author of
the original message, I haven't recognized a pattern or found a solution.
^^^^^^^^^Steve Bratten^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| _ o__ |
| ( \ _/_ _.>/^_ BITNET < GE0793@SIUCVMB > |
| \ / _ _ _ (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > |
| \_) (__(/_/(_/\_(/_ |
| __ \o \o \o Graduate School |
| |__) __ __ -/-/-_ __ |> |> |> Southern Illinois University |
| |__) / (_(_/(_/`/_(/_/// < \ < \ < \ Carbondale, IL 62901-4716 |
| |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date: Fri, 6 Aug 1993 09:11:04 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: George Waller <HBLADM47@UCONNVM.BITNET>
Subject: Is Access 1.1 FTP available?
Is Access 1.1 available for FTP and if not, could someone
make it available? My understanding is that there is no
licensing problem with doing so.
=========================================================================
Date: Fri, 6 Aug 1993 10:35:35 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: ? How to copy (backup) an .mdb
In trying to apply the KISS principle to the application I'm writing for
my supervisor :), I have run up against a slight problem. I need to
assign some code to a command button that will copy the entire .MDB file
to the A: drive for the purpose of making an archival backup. I realize
she could do this by going to the File Manager and dragging and dropping
the file to A:, but she's used to the kludge I whipped up in dBase that
performed this operation.
Am I going to run up against sharing violations when I try to copy the
(open) .MDB to disk? Something tells me that I will.
Should I shell out to the File Manager (as demonstrated using the Calculator
in the Shell section of the Language Reference) to accomplish this feat?
Or should I just forget it and tell her to use the File Manager? :)
Thanks for any advice.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Fri, 6 Aug 1993 10:52:05 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "ROBERT GRINNELL,
SEATTLE PACIFIC UNIVERSITY" <r_grinnell@LUKE.SPU.EDU>
Subject: Re: ACCESS-L Digest - 4 Aug 1993 to 5 Aug 1993
On Fri, 6 Aug 1993 09:50:27 MEZ, Erich Neuwirth writes:
>i just got my software upgrade for access (1.1)
>there is an offer in ther for the documetation for $ 49.50
>having the printed docs for 1.0,
>is it worthwhilw buying the updated documentation?
>any recommendations?
This was a concern of mine, too, until the upgrade arrived. After
reviewing the What's New in Version 1.10 help file (MSA110.HLP),
I concluded that none of the changes was of a type that would alter
the documentation substantially or pervasively. They are all pretty
distinct and self-contained. The help file tells you all you need.
Robert Grinnell
Seattle Pacific University
r_grinnell@luke.spu.edu
=========================================================================
Date: Fri, 6 Aug 1993 11:44:03 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "ROBERT GRINNELL,
SEATTLE PACIFIC UNIVERSITY" <r_grinnell@LUKE.SPU.EDU>
Subject: Re: ? How to copy (backup) an .mdb
On Fri, 6 Aug 1993 10:35:35 EST, Nathan Brindle writes:
>In trying to apply the KISS principle to the application I'm writing for
>my supervisor :), I have run up against a slight problem. I need to
>assign some code to a command button that will copy the entire .MDB file
>to the A: drive for the purpose of making an archival backup. I realize
>she could do this by going to the File Manager and dragging and dropping
>the file to A:, but she's used to the kludge I whipped up in dBase that
>performed this operation.
>Am I going to run up against sharing violations when I try to copy the
>(open) .MDB to disk? Something tells me that I will.
>Should I shell out to the File Manager (as demonstrated using the Calculator
>in the Shell section of the Language Reference) to accomplish this feat?
>Or should I just forget it and tell her to use the File Manager? :)
My guess (and I am operating at the edges of my knowledge here) is that
your only chance of doing this with the .MDB open is to make a WinAPI
call from within the database to do the copying. Anything else would hit
a share violation, since the file in question is registered to Access
in Share's system. But having not tried it, I sure can't guarantee the
WinAPI call would work, either. Guess that's for you to find out. I'd
like to know if it works, it could be a very useful general purpose function.
Robert Grinnell
Seattle Pacific University
r_grinnell@luke.spu.edu
=========================================================================
Date: Fri, 6 Aug 1993 21:08:28 +0200
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "M. Ederveen" <MARTIN@HSEPM1.HSE.NL>
Subject: Re: Erratic Screens
I do not experience your change-screen fonts problem.
There could be something wrong within Windows, fonts tend to be thrown
around in the memory a lot, maybe some problem there?
Also you might be running some virus, other resident program or faulty
mouse-driver?
Martin Ederveen
=========================================================================
Date: Fri, 6 Aug 1993 16:14:00 LCL
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: MKRO <MKRO.DIS-PC@BMAILIN.ITG.TI.COM>
Subject: I/O with Barcodes for MS Access
Has anyone come across any information about using I/O from a barcode reader
to supply data for
MS Access forms and controls? I have APP that manages inventory, it sure
would be slick if I could
scan information in and out, updating tables and screens!
=========================================================================
Date: Fri, 6 Aug 1993 16:41:19 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: ? How to copy (backup) an .mdb
In-Reply-To: Message of Fri,
6 Aug 1993 11:44:03 PDT from <r_grinnell@LUKE.SPU. EDU>
One thing that came to mind on this question was to create an empty .mdb
on the backup floppy and use TransferDatabase or CopyObject to move each
object, one at a time, to the backup .mdb. This strikes me as a losing
kludge (worse than the one I wrote in dBase to do the same thing), and
it seems to me that MS needs to give us a BackupDatabase command in the
next version. Being LANless and essentially backupless here in academia
:), I've got to think of SOMETHING.
Like I say, however, I'll probably end up telling my supervisor to use
the File Manager and move the file manually to floppy.
Merry Weekend....:)
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Fri, 6 Aug 1993 14:53:20 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Re: I/O with Barcodes for MS Access
In-Reply-To: <9308062123.AA02326@hermes.intel.com>; from "MKRO" at Aug 6,
93 4:14 pm
> Has anyone come across any information about using I/O from a barcode reader
> to supply data for
> MS Access forms and controls? I have APP that manages inventory, it sure
> would be slick if I could
> scan information in and out, updating tables and screens!
There are a number of things you can do with scanners and a database
application, and they all apply to Access. The first I can think of is
real-time data entry, kind of like scanning groceries or something. With
this, if the data entry point is fixed (a cash register or something), you
can actually connect a scanner to the PC in-between the keyboard and the
PC. Then, the scanner and decoder send input to the PC as if it had been
entered by the keyboard.
The other major thing is data collection. Like, if you conducting an inventory
of a warehouse or something. Here you will want a portable data collection
scanner unit. It may be something simple, or sophisticated. In either case,
all you need is a common data format, which is usually something as simple
as a common delimited text file. If you want to check the inventory as
you scan, you'll need to dump the data from Access to the scanner via this
text file, and then conduct your inventory with the scanner. Or, you may
want to just go scan barcodes, and then dump the data from the scanner to
Access using a text file, and then let Access reconcile it.
I will be using Access to do a combination of all three within a few weeks.
We're going to upload a large database of information to a high-end portable
scanner, which will then be used to conduct audits or inventories of
equipment, but also provide more information, like where the equipment is
at, who is using it, and so forth, all of which can be checked while doing
the invetory/audit. Then, we'll make corrections in real-time using keyboard
input to the scanner, and when all done, upload those corrections back to
the database in Access.
We already do something similar in dBase, but it will be no different with
Access. You just write some AccessBasic code to pull in the data from the
text file (which, if the format is right, can be done with just a couple
lines of code), and then process that data. Of course, we're paying big
money to the company which is programming the scanner so that it can handle
its end of the job.
And of course, we'll also be linking Access with another piece of software
which will print barcodes on a thermal barcode printer. It should all be in
place in about 3 weeks (although it took twice as long to develop the
specifications for the whole system).
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Fri, 6 Aug 1993 14:54:42 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Re: I/O with Barcodes for MS Access
In-Reply-To: <9308062123.AA02326@hermes.intel.com>; from "MKRO" at Aug 6,
93 4:14 pm
Forgot something. For uploading/downloading large amounts of information, you
can use a standard telecommunications program like ProComm, which you can
also automate to do the whole job automatically. This way you don't worry
about the I/O within Access, just the delimited text files.
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Sat, 7 Aug 1993 15:08:11 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Steve Miller <miller@ROADRUNNER.PICTEL.COM>
Organization: PictureTel Corporation
Subject: Access Utility Uploaded to CICA
I just uploaded a utility to ftp.cica.indiana.edu that I
downloaded from Compuserve. Here is part of the description
file:
Description
===========
Access Spell-Rite is an add-in module that you can use to
help with spelling of object names, field names, and control
names. It lists every object in your database, including
field names, control names, and macro group names. You can
have it copy any of these names to the clipboard, adding
square brackets [] if necessary. It is then a simple
procedure to paste the name where it is required.
Access Event-Finder is an add-in module that you can use to
help locate events on a form or report, so you can track down
odd behaviour caused by macros and modules.
--
+-------------------------------------------------------+
| Steve Miller PictureTel Corporation |
| email: miller@pictel.com One Corporation Way |
| phone: (508) 977-8235 Peabody, MA 01960 |
+-------------------------------------------------------+
=========================================================================
Date: Sat, 7 Aug 1993 14:46:20 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Linda D. Cornell" <lcornell@U.WASHINGTON.EDU>
Subject: 2 Questions
I need to pass the data entered in one field to a query used to generate
a combo box for the next field. For example, in field 1 the user selects
code 1 (from a combo box). I need to pass code 1 to the query that
generate the combo box for field 2. I wrote a parameter query that
works fine until I put it into the form. Does anyone have any advice?
Also, has anyone been successful updating a field based upon data
entered into a previous field? For example, field 2 is updated
based upon the data entered into field 1.
Thanks.
Rochelle Cole (who is helping Linda Cornell and using her account)
Thanks from me too!
Linda Cornell
lcornell@u.washington.edu
=========================================================================
Date: Sun, 8 Aug 1993 11:28:07 CDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Richard Moldwin <rmoldwin@MIDWAY.UCHICAGO.EDU>
Subject: Re: Erratic Screens
In-Reply-To: Your message of Fri, 6 Aug 1993 08:55:33 EDT
Mike, I'm having the exact same problem with screen fonts. I'm using a
Gateway 486DX2/50 with 8MB RAM and an ATI-Ultra (not local bus). What's your
configuration?
---Rich Moldwin
=========================================================================
Date: Sun, 8 Aug 1993 21:17:21 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Bill Stewart <STEWART@GC.BITNET>
Subject: Access Tip
I just got done figuring out how to make the toolbar reappear after turning
it off through a macro (and using a custom menu bar on a form). I was
trying to use the sendkeys command and it wasn't working. Apparently if
the menu bar of the form you're working on doesn't have the menu item to
select it can't be choosen.
The work around (via the PIM example) is to select the Database window by
using the select object command in the same macro as the send keys command.
My rational that this works is that you have to select an object or form
that has the menu item you want to select.
------------------------------------------------------
Bill Stewart
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date: Mon, 9 Aug 1993 09:49:41 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Access Tip
In-Reply-To: Message of Sun, 8 Aug 1993 21:17:21 -0700 from <STEWART@GC>
That's the same workaround that I doped out last Thursday to do the
exact same thing. Minds must be working in parallel on this list...:)
My macro (part of the CloseProject macro that runs when I hit the Exit
button in my main form) looks like this:
SendKeys
Keystrokes: {TAB}{TAB}{TAB}YES{ENTER}
Wait: No
DoMenuItem
Menu Bar: Database
Menu Name: View
Command: Options
Somewhere I read that it is mandatory to do the SendKeys <before> you
execute the command they belong to.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Mon, 9 Aug 1993 10:35:06 EDT
Reply-To: arbert@aol.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Brett Archer <arbert@AOL.COM>
Subject: Re: ? How to copy (backup) an...
Have you tried to use the TransferDatabase "command" to backup a database?
=========================================================================
Date: Mon, 9 Aug 1993 07:29:33 +0000
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Marty McMahon <Marty.McMahon@KAUAI.DS.BOEING.COM>
Subject: GRAPHS IN ACCESS
'm relatively new to the use of ACCESS. Is there a good book that explains
how to build and modify graphs using ACCESS? Does it make more sense to
export to Excel and make them there?
marty.mcmahon@kauai.ds.boeing.com
=========================================================================
Date: Mon, 9 Aug 1993 11:38:03 -0600
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Tim Mackay <tmackay@MEI.COM>
Subject: PageMaker -> RTF -> Access
I've been assigned with a special project that requires me to get data from
Aldus PageMaker into Microsoft Access. The data consists of PartNumbers,
Descriptions, Notes, and Prices for parts, and the parts fall into a series
of Categories. The PageMaker data isn't tabular, but the fields are
formatted in different ways on different lines.
I understand that PageMaker will export RTF - ascii text with embedded
formatting commands - and that Access will import ascii text, so I figure
that RTF is a good intermediary step. Once I have an RTF file, I'll parse
the RTF with Access, putting underlined lines into the Categories field,
bold lines into the Description fields, italic lines into the Notes field,
etc. Sound dooable?
My question is:
Is there an RTF specification available anywhere on the 'net so I can
better understand how to read RTF files' embedded commands?
or
Where can I learn more about RTF files and how they're formatted.
or
Is there an easier way to do this?
Thanks in advance for any help.
Tim Mackay |paper-net:Marquette Electronics, Inc
internet: tmackay@mei.com | 8200 W Tower Ave
voice-net:(414) 362-2765 | Milwaukee, WI 53223
=========================================================================
Date: Mon, 9 Aug 1993 11:51:04 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: PageMaker -> RTF -> Access
In-Reply-To: Message of Mon, 9 Aug 1993 11:38:03 -0600 from <tmackay@MEI.COM>
Since there's no PageMaker filter for Access, I'd be <more> inclined to
put the data into tabular form, create the corresponding table in Access,
and cut and paste. I don't know if this will work but I'm going to play
with it here in a minute and see.
If it's possible to export from PM into dBase IV, I'd be more inclined to
go that route and then import the resulting .dbf into Access. Again, I
don't know if the dBase IV filter is two-way or just one-way in Pagemaker.
<Does> Access import RTF? That's news to me if so.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Mon, 9 Aug 1993 11:58:57 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: PageMaker -> RTF -> Access
In-Reply-To: Message of Mon, 9 Aug 1993 11:38:03 -0600 from <tmackay@MEI.COM>
I misunderstood what you were going after. For some reason I read you
as saying you wanted to export <tabular> data from PM. You can indeed
Paste Append tabular data copied to the clipboard from PM into Access.
Whether your other idea (export to RTF then import and parse in Access)
would work is something I can't answer.
Sorry if I confused the issue. Can you work with a copy of the PM file
and put the data into tabular form? If the file isn't too big and you
aren't talking about too many records, that seems like the easiest thing
to do.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Mon, 9 Aug 1993 13:54:36 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Phillip (Phil) Paxton" <72410.2162@COMPUSERVE.COM>
Subject: PageMaker -> RTF -> Access
% I've been assigned with a special project that requires me to get data from
% Aldus PageMaker into Microsoft Access. The data consists of PartNumbers,
% Descriptions, Notes, and Prices for parts, and the parts fall into a series
% of Categories. The PageMaker data isn't tabular, but the fields are
% formatted in different ways on different lines.
% I understand that PageMaker will export RTF - ascii text with embedded
% formatting commands - and that Access will import ascii text, so I figure
% that RTF is a good intermediary step. Once I have an RTF file, I'll parse
% the RTF with Access, putting underlined lines into the Categories field,
% bold lines into the Description fields, italic lines into the Notes field,
% etc. Sound dooable?
I'll play techno-cynic for a moment -- just be prepared to do some handholding
-- it never fails when
migrating data from a free format arena to a structured arena. A good example
of this type of problem comes
when people use things like Excel (I'm not picking on Microsoft, Lotus123,
Quattro Pro, etc. can be
substituted) as a database then realize they need to "move up" to a real
database system and suddenly find
they have to define their fields as long text strings or memo fields because so
many exceptions to the [data]
rules suddenly appear.
I've seen a lot of this over time and received a lot of phone calls in the last
year or so from friends and
former co-workers who are in the process of migrating just such a situation --
suddenly the "this is the name
field" becomes "well, it's the name field for everyone else, but since we didn't
know his real name, we put
this here..." (you can imagine how the rest of the conversation went).
I guess what I'm trying to say is: don't be surprised if you suddenly find not
all bold is a description, or that
all descriptions aren't necessarily bold, etc. etc. -- and the best part is,
it'll run smoothly until you are busy
on ten other projects and suddenly someone of Dutch extraction decides to throw
their wooden shoes into
the fray...
P.S.
On a lighter note, keep us posted -- it sounds like an interesting project.
(Good Luck)
Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date: Mon, 9 Aug 1993 13:08:00 -0600
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Tim Mackay <tmackay@MEI.COM>
Subject: Re: PageMaker -> RTF -> Access
>Can you work with a copy of the PM file
>and put the data into tabular form? If the file isn't too big and you
>aren't talking about too many records, that seems like the easiest thing
>to do.
The file is HUMUNGOUS, and that's why I'm even considering this kind of work.
Tim Mackay |paper-net:Marquette Electronics, Inc
internet: tmackay@mei.com | 8200 W Tower Ave
voice-net:(414) 362-2765 | Milwaukee, WI 53223
=========================================================================
Date: Mon, 9 Aug 1993 12:00:39 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "ROBERT GRINNELL,
SEATTLE PACIFIC UNIVERSITY" <r_grinnell@LUKE.SPU.EDU>
Subject: Re: GRAPHS IN ACCESS
On Mon, 9 Aug 1993 07:29:33 +0000 Marty McMahon writes:
>'m relatively new to the use of ACCESS. Is there a good book that explains
>how to build and modify graphs using ACCESS? Does it make more sense to
>export to Excel and make them there?
Don't know about books. As for Excel vs. Graph, I'd recommend using
Graph for anything that you are going to use over again. If you just
want a one-time graph and are more adept with Excel than Graph, then
you would probably want to just copy the data over to Excel and go from
there.
Robert Grinnell
Seattle Pacific University
r_grinnell@luke.spu.edu
=========================================================================
Date: Mon, 9 Aug 1993 21:13:59 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Bill Stewart <STEWART@GC.BITNET>
Subject: Re: GRAPHS IN ACCESS
From the little bit of expirence I've had with graphs I've found that the
power is within the query. It took me awhile to create the query that
would generate the graph I wanted. To me it sounds like it would be easier
to generate a graph in excel, but I'm going to make the be of MS graph.
I have a budget database that has the ability to show a bar graph of the
spending by department. Kind of slick. I really hate the idea of the
users of this database having to generate a report in excel format than
launch excel to see the chart.
Good luck!
------------------------------------------------------
Bill Stewart
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date: Tue, 10 Aug 1993 08:42:49 CST
Reply-To: jao9w265@aurora.cdev.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "John A. Olson" <jao9w265@AURORA.CDEV.COM>
Subject: How do we run .exe, .bat etc. from within A. B.
Hello,
It's been a long time since I sat down and sent something to this list.
I am trying to write a function in Access Basic which at one point needs
to run a MSDOS batch file before continuing on. My problem is that although
I can use the SHELL command to start the batch file running, the Access
Basic code continues running before tha batch file even executes. This
is unsatisfactory. How can I write some code to cause the execution of the
function to halt temporarily until the batch file has completed its course
of action?
The Shell function is found in the language reference and looks like this:
x = Shell("xxxx.bat" , 5)
where the number indicates the type of window to run the executable file in.
HELP! I have a deadline on this project and I need some good advice quickly.
Thank You.
John Olson
Computing Devices International
f.k.a. Control Data Corporation
=========================================================================
Date: Tue, 10 Aug 1993 15:59:00 LCL
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: MKRO <MKRO.DIS-PC@BMAILIN.ITG.TI.COM>
Subject: Printing "Form Letters"
Searching for design ideas/experience with printing "form" letters in MS
ACCESS.
Would like to take a preformatted text letter, pull name and address
information from an access table while in an MS ACCESS application, and print
the letter. Also be able to give the users a way to edit the
preformatted text letter. ANY SUGGESTIONS? I have been contemplating
exports to MS WORD, POKES to a WORD document, hardcoding the text in an
ACCESS Basic module...Ect. Is there a
cleaner way?
=========================================================================
Date: Tue, 10 Aug 1993 18:12:19 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Phillip (Phil) Paxton" <72410.2162@COMPUSERVE.COM>
Subject: Printing "Form Letters"
% Searching for design ideas/experience with printing "form" letters in MS
% ACCESS.
% Would like to take a preformatted text letter, pull name and address
% information from an access table while in an MS ACCESS application, and print
% the letter. Also be able to give the users a way to edit the
% preformatted text letter. ANY SUGGESTIONS? I have been contemplating
% exports to MS WORD, POKES to a WORD document, hardcoding the text in an
% ACCESS Basic module...Ect. Is there a
% cleaner way?
When you say "POKE", you mean DDE POKE, right? (Not the old PC-BASIC POKE)
Take a look at 1.1 -- when you export a table, one of the options is "Word for
Windows Merge".
(I think that'll solve your problem)
Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date: Wed, 11 Aug 1993 16:47:39 +1000
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: David Doan <s9390066@AIX00.CSD.UNSW.OZ.AU>
Subject: Help with calling functions in user-defined DLL from Access Basic?
Hello,
Is it possible to call functions in user-defined DLL ?
I have followed examples from Intro to Programming and use
the Declare statement and all that but when I tried call functions
in my own DLL I get an error message which says "Duplicate procedure name"
I suppose I could use the windows API to call the functions in my DLL
but perhaps someone can show me a better way of doing this.
Thanks.
David Doan
=========================================================================
Date: Wed, 11 Aug 1993 16:08:27 GMT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Richard Saunders, Computer Centre" <RICHARD@BKMAIN.UEL.AC.UK>
Organization: University Of East London
Subject: Multiple copies of mailing label
Hi! I am a new user of Microsoft Access, and hence of this discussion
list. I have created a names and addresses table to use for
mailing labels but I can't work out how to print multiple copies of a
single label. I don't want to use the Copies option of the Windows
Print Manager because that prints each label on a new page.
Ideally I would like to add a "Number of copies" field to the table
(from 0 to 999, say) and have Access print labels for the whole table
based on that field.
Any tips would be appreciated. Thanks.
=========================================================================
Date: Wed, 11 Aug 1993 10:33:14 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Multiple copies of mailing label
In-Reply-To: Message of Wed,
11 Aug 1993 16:08:27 GMT from <RICHARD@BKMAIN.UEL. AC.UK>
The answer is: FTP the file ACC-KB.EXE from FTP.CICA.INDIANA.EDU (or
its mirrors) where it is still sitting in /pub/pc/win3/uploads/JUN93.
ACC-KB.EXE is a self-extracting archive of the ACC-KB.HLP file which
is the Access Knowledge Base. One of the articles in the Knowledge
Base addresses the issue of making multiple copies of the same label.
Alternately, if you have no FTP access but can handle a UUencoded file
and know how to use the LISTSERV file archive commands, it is available
from LISTSERV@INDYCMS in four pieces. Send the command IND ACCESS-L to
LISTSERV@INDYCMS to obtain a filelist to get the exact names (my memory
doesn't extend that far...sorry!).
HTH
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Wed, 11 Aug 1993 10:34:27 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: schuck@SFU.CA
Subject: Re: Multiple copies of mailing label
In-Reply-To: <9308111635.AA11348@whistler.sfu.ca>; from "Richard Saunders,
Computer Centre" at Aug 11, 93 4:08 pm
>
> Hi! I am a new user of Microsoft Access, and hence of this discussion
> list. I have created a names and addresses table to use for
> mailing labels but I can't work out how to print multiple copies of a
> single label. I don't want to use the Copies option of the Windows
> Print Manager because that prints each label on a new page.
>
> Ideally I would like to add a "Number of copies" field to the table
> (from 0 to 999, say) and have Access print labels for the whole table
> based on that field.
>
> Any tips would be appreciated. Thanks.
>
Off the top of my head, I can think of a quick and dirty method for a
reasonable number of copies ie 1 - 10.
Create a copy table with 1 field [No of copies]
There would be 1 record with a 1, 2 records with a 2 , etc
ie:
1
2
2
3
3
3
4
4
4
4
Base your label printing on a query that joins the [No of copies] on
your address table to the no_of_copies table.
A 3 copies record would appear 3 times in the query.
This method would work without using Access Basic.
=========================================================================
Date: Wed, 11 Aug 1993 14:41:01 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Variables in sql statements in basic
I think this has been discussed before perhaps, but I haven't had the time
to read the list much lately. I'm going to be doing some CreateDynaset
operations in AccessBASIC soon, and will be basing them off of SQL statements.
My experience with AccessBASIC thus far is that almost every operation has
its own expression-building/syntax quirks. Before I get into it, what is
the best way basing that SQL statement on data in a variable? In other words,
I need the WHERE clause to be flexible. Can someone give me an example of
how they do this? I may find it is simple enough, but experience tells me
I'm going to waste time if I don't just ask first.
Thanks in advance.
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Fri, 13 Aug 1993 09:23:00 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Skewes-Cox, Tom" <tskewes@SAONET.UCLA.EDU>
Subject: Moving to beginning of Tab order
I am trying to write a generic navigation macro for data entry/edit forms
that will move to the next record and place the focus on the first control
in the tab order. I am trying to avoid having to create a form specific
GoToControl command for each form. Is there a macro command that can do
this or do I need to get into Basic.
If I do need to use Basic how do you access the tab order of a form?
*-------------------------------*-----------------------------------*
* Tom Skewes-Cox * *
* Research Associate * Phone : (310) 206-8470 *
* Student Affairs Information * *
* and Research Office * E-Mail: tskewes@saonet.ucla.edu *
* 274 Kinsey Hall * *
* Los Angeles, CA 90024-1324 * Fax : (310) 206-2978 *
* UCLA Mail Code: 132405 * *
*-------------------------------*-----------------------------------*
=========================================================================
Date: Sat, 14 Aug 1993 16:42:21 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Linda D. Cornell" <lcornell@U.WASHINGTON.EDU>
Subject: Need help with a surly subform
Hi there,
Has anyone out there managed to create a form that has a command button
which opens a subform? We can get a subform to work just fine imbedded in
the parent form, however, it really slows down the performance of the
parent form, and the subform information isn't always needed. We just
want to be able to call it when we want it!
If we use the button we made to just open a regular form, we get all the
records in the table associated with that secondary form, rather than just
the records that would be chosen with a subform.
We've tried using the macro behind the button to link the key information
from the record on the main form to a secondary form's data file, but we can't
get that to cooperate either.
What are we doing wrong - are we just coming at this wrong? Any help will
be appreciated.
Thanks in advance for any assistance!
Linda Cornell
lcornell@u.washington.edu
UW Office of Research
=========================================================================
Date: Sun, 15 Aug 1993 00:36:26 -0700
Reply-To: Kristina Sontag <airplane@halcyon.com>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Kristina Sontag <airplane@HALCYON.COM>
Subject: Re: your mail
In-Reply-To: <199308021701.AA17200@halcyon.com>
If I understand the question correctly, the simple way to do this (force page
breaks to only happen after a record, not in the middle of one) is to set the
section property "Keep Together" to yes. That, in fact, is the only way I
do it. You may have to play around with your report format slightly to
avoid too much blank space at the bottom of the page, but this property
will eliminate the problem of records being split across two pages. I hope
that helped!
--kris
--airplane@halcyon.com
=========================================================================
Date: Mon, 16 Aug 1993 10:24:09 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Chan Chor Ling <NCLCHAN@NTUVAX.NTU.AC.SG>
Subject: Re: need help with a surly subform
Dear Linda,
Try to make use of the Where Conditions in your macro to open the subform.
eg. When U press the command button, it will execute the macro, OpenSubForm
Macro - Openform
Form Name : SubformName
View : Form
Where : [SubformControlName] = Forms![MainFormName]![MainFormControlName]
....
If U don't know what I mean, please read Page 535 of Microsoft Access User's
Guide.
Chor Ling
=========================================================================
Date: Mon, 16 Aug 1993 10:30:08 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Chan Chor Ling <NCLCHAN@NTUVAX.NTU.AC.SG>
Subject: Microsoft Access Analyser
I tried to analyse my table using Microsoft Access Runcode - StartAnalyzer().
I discovered that there is some discrepancies. One of my field which is not
indexed has an indexname after I analyse the table.
Has anyone encountered something like this before ? How do U overcome it ?
Chor Ling
NCLCHAN@NTUVAX.NTU.AC.SG
=========================================================================
Date: Mon, 16 Aug 1993 10:31:57 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: NCLCHAN@NTUVAX.BITNET
Subject: Re: Analyzer
Dear Nathan,
I am so sorry. Please ignore my letter Analyzer. I make a mistake. The IndexName
Reference 2 indicates foreign key rather than indexName, if I am not mistake
n this time. Please delete my letter.
Chor Ling
NCLCHAN@NTUVAX.NTU.AC.SG
=========================================================================
Date: Mon, 16 Aug 1993 15:02:00 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Briganti, Joe" <j.briganti@TRL.OZ.AU>
Subject: Problem reading Pdox file from Access
Help.
I've been trying to read a Paradox file from my Access db but keep getting
asked for its password. I've believe I have removed all security passwords
from the Paradox end but to no avail.
Anybody out there fluent in Access and Paradox able to help me?
I'm using Access 1.1 and Paradox 1.0 (for Windows). I'm trying to attch to
the sample
Paradox table called biolife (found in diveplan I think!)
--
Joe Briganti ( j.briganti@trl.oz.au)
=========================================================================
Date: Mon, 16 Aug 1993 16:58:10 +1000
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Graeme Burton <G.Burton@SEC.GU.EDU.AU>
Subject: Re: ACCESS-L Digest - 13 Aug 1993 to 14 Aug 1993
have the join field in both forms.
The macro called when you press the button will open the second
form - use the where box to ensure that the join fields are the same.
Cheers.
===============================================================================
Graeme Burton | |
Student Systems Manager| | Phone: (07) 875 7500
Griffith University | email: G.Burton@gu.edu.au |
Nathan 4111 | | Fax: (07) 875 7957
Australia | |
===============================================================================
=========================================================================
Date: Mon, 16 Aug 1993 13:23:23 GMT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Richard Saunders, Computer Centre" <RICHARD@BKMAIN.UEL.AC.UK>
Organization: University Of East London
Subject: Multiple copies of labels
>
> Off the top of my head, I can think of a quick and dirty method for a
> reasonable number of copies ie 1 - 10.
>
> Create a copy table with 1 field [No of copies]
>
> There would be 1 record with a 1, 2 records with a 2 , etc
>
> ie:
>
> 1
> 2
> 2
> 3
> 3
> 3
> 4
> 4
> 4
> 4
>
> Base your label printing on a query that joins the [No of copies] on
> your address table to the no_of_copies table.
>
> A 3 copies record would appear 3 times in the query.
>
>
> This method would work without using Access Basic.
Thanks for this suggestion and to Nathan Brindle for indicating the
article "Skip Used Mailing Labels and Printing Duplicate Labels" in
the Knowledge Base, which I have now read.
In the end I decided to keep things simple and base my printing on a
parameter query. First I created a table with a single field
containing values from 0 to 999. (I set this up as a counter type
field and made it the primary key, but both these steps are
optional - I think.)
Then I created a query to choose the labels(s) I want to print.
Finally I created a parameter query based on the above table
and query (not joined). I added the counter field to the QBE grid
but turned off its "Show" checkmark, then added the criterion
< [How many copies do you want?]
to this field.
Now when I run my parameter query it asks "How many copies do you
want?" If I enter say, 50, it creates a dataset with 50
duplicates of my chosen label(s), corresponding to counter fields 0 to
49.
I included a SORT in my parameter query so that if I am choosing more
than one label, the labels for each record are printed in separate
blocks, instead of alternating.
I think all I need to do now is base my mailing labels report on this
parameter query.
=========================================================================
Date: Mon, 16 Aug 1993 10:22:41 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Analyzer
In-Reply-To: Message of Mon, 16 Aug 1993 10:31:57 +0800 from <NCLCHAN@NTUVAX>
Oh well, we all make mistakes...especially me. :) Unfortunately, once you
send it, it's sent...this isn't an edited list. So don't worry about it...
ncb
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Mon, 16 Aug 1993 11:37:05 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Greg Fairnak <GFAIRNA@AMERICAN.EDU>
Organization: The American University
Subject: Re: Microsoft Access Analyser
In-Reply-To: Message of Mon,
16 Aug 1993 10:30:08 +0800 from <NCLCHAN@NTUVAX.NTU.AC.SG>
Which version of Access are you running? 1.0 or 1.1
=========================================================================
Date: Mon, 16 Aug 1993 08:42:32 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Jim Renaud <wiseguy@MCODE.AMDAHL.COM>
Subject: Re: Problem reading Pdox file from Access
>
> Help.
>
> I've been trying to read a Paradox file from my Access db but keep getting
> asked for its password. I've believe I have removed all security passwords
> from the Paradox end but to no avail.
>
> Anybody out there fluent in Access and Paradox able to help me?
>
> I'm using Access 1.1 and Paradox 1.0 (for Windows). I'm trying to attch to
> the sample
> Paradox table called biolife (found in diveplan I think!)
> --
> Joe Briganti ( j.briganti@trl.oz.au)
>
The problem is that Borland changed the format of it's database (incompatible)
from 3.5 to 4.0. As far as I know, Access only supports the 3.5 version of
Paradox for now. Paradox for Windows uses the new 4.0 engine.
I'm not a Paradox expert, but I think it would work if you could export your
Paradox for Windows database to a Paradox 3.5 engine format.
-----------------------------------------------------------------------
Jim Renaud [Standard Disclaimer]
Amdahl Corporation
M/S 205 Phone: 408-992-2662
Bldg. M3 Room 235 Fax: 408-773-0833
1230 E. Arques Avenue Email: wiseguy@mcode.amdahl.com
Sunnyvale, CA 94088-3470
=========================================================================
Date: Mon, 16 Aug 1993 13:47:15 -0600
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Tim Mackay <tmackay@MEI.COM>
Subject: Re: How do we run .exe, .bat etc. from within A. B.
jao9w265@aurora.cdev.com writes:
>I am trying to write a function in Access Basic which at one point needs
>to run a MSDOS batch file before continuing on. My problem is that although
>I can use the SHELL command to start the batch file running, the Access
>Basic code continues running before tha batch file even executes. This
>is unsatisfactory. How can I write some code to cause the execution of the
>function to halt temporarily until the batch file has completed its course
>of action?
>
>The Shell function is found in the language reference and looks like this:
>
> x = Shell("xxxx.bat" , 5)
>
>where the number indicates the type of window to run the executable file in.
Here's how I'd try to do it. Mind you, I haven't tried this yet, so it
might not work.
In the last line of your batch file, have it make a dummy file:
dir > c:\dummy.txt
In Access Basic, right after you shell to your batch file, write a Do
Until...Loop that does a directory and checks for the existence of the
dummy file. When it finds the dummy file, you know that the batch file is
done processing.
Continue with your code after the dummy is found, and delete dummy.txt when
your function is done (or maybe wait a little longer to avoid sharing
violations).
Hope this helps.
Tim Mackay |paper-net:Marquette Electronics, Inc
internet: tmackay@mei.com | 8200 W Tower Ave
voice-net:(414) 362-2765 | Milwaukee, WI 53223
=========================================================================
Date: Mon, 16 Aug 1993 14:22:33 -0600
Reply-To: jao9w265@aurora.cdev.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "John A. Olson" <jao9w265@AURORA.CDEV.COM>
Subject: Re: running .bat from Access
In message Mon, 16 Aug 1993 01:36:13 -0700 (PDT),
dmitry@ucsee.Berkeley.EDU (Dmitry Serebrennikov) writes:
> Hello,
> this is got to be the most awful and horrible solution the you'll get,
> but... If you are using .bat files about the only thing they can do is to
> create files, right, so you can test in access basic for existence of a
> file by trying to open it using Open command (just a generic DOS file open
> thing) and doing errorhandling appropriately. I told you it was awful!
> Well, come to think of it, you could use environment variables, I think I
> saw somewhere in access something like GetEvironment or the like. That
> would be even slick (comparing to the previous idea) uh.
>
> Good luck.
> Dmitry@ucsee.berkeley.edu
>
Thank you for responding. I did manage to find a very effective way to
accomplish this feat. It involves using a Windows API function named
GetModuleUsage. The correct declaration and syntax follow for anyone
who may be interested in doing the same thing I needed to do.
In the Declarations section of your Access Basic module, enter the following
line:
Declare Function GetModuleUsage% Lib "Kernel" (ByVal hProgram%)
Then, in whatever function is shelling out to run a Dos Executable program,
use the following code to cause the function to "wait" until that DOS
program has run its course:
x = Shell([Executable filename], 6) 'The 6 is insignificant, check the book.
While GetModuleUsage(x)
DoEvents
Wend
The real key here is that while the executable is still running,
GetModuleUsage returns a value of True. Once it has finished running,
GetModuleUsage returns False and your Access Basic function can exit the
While Loop and continue on its merry way. The DoEvents command lets the
computer continue running other tasks even though the function appears to be
in an infinite loop.
I Hope this proves useful to others as well.
Regards,
John A. Olson
Computing Devices International
jao9w265@aurora.cdev.com
=========================================================================
Date: Mon, 16 Aug 1993 12:58:00 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Morris Myers <xrysta@MCODE.AMDAHL.COM>
Subject: Re: Problem reading Pdox file from Access
> Help.
>
> I've been trying to read a Paradox file from my Access db but keep getting
> asked for its password. I've believe I have removed all security passwords
> from the Paradox end but to no avail.
>
> Anybody out there fluent in Access and Paradox able to help me?
>
Access cannot read Paradox 4.0 tables. If you want to read Paradox 4.0 tables
(same database engine as Pdox for Windows) from Access you must convert them
to 3.5 format. I am not sure you can do that with Pdox for Windows (I gave up
on Pdox for Windows when Access became available). You can perform that
conversion feat with Pdox 4.0 for DOS.
> I'm using Access 1.1 and Paradox 1.0 (for Windows). I'm trying to attch to
> the sample
> Paradox table called biolife (found in diveplan I think!)
> --
> Joe Briganti ( j.briganti@trl.oz.au)
>
--
-----------------------------------------------------------------------
Morris Myers [Standard Disclaimer]
Amdahl Corporation
M/S 205 Phone: 408-746-4798
Bldg. M3 Room 311 Fax: 408-629-4374
1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com
Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us
=========================================================================
Date: Mon, 16 Aug 1993 13:43:42 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Dmitry Serebrennikov <dmitry@UCSEE.BERKELEY.EDU>
Subject: Transactions and forms.
Well, it's my time to ask questions.
I have been experimenting with Transactions in Forms and didn't get much luck
with them. Specifically I have a form that provides an access to customer
accounts (doesn't really make a difference but for the sake of example...)
So I want to have the form in read only mode until the Edit button is pressed.
Then I AllowEditing and continue until they press Save. I got that to work,
butI also wanted to start a transaction when Edit is pressed and Commit it when
Save is pressed (so I could also make Undo button).
Now the form has a few subforms. Do you know if one transaction will handle
many tables?
In my experiments I got confused in how to handle leaving the current record
(between OnCurrent and OnAfterUpdate properties). And also the rollback didn't
seem to roll anything back...
It is very possible that I am missing something obvious. Could someone who had
experience with this kind of thing shed some light on how they've implemented
similar situation.
Tankx in advance.
dmitry@ucsee.berkeley.edu
=========================================================================
Date: Mon, 16 Aug 1993 13:51:24 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Re: Transactions and forms.
In-Reply-To: <9308162046.AA00542@hermes.intel.com>; from "Dmitry
Serebrennikov" at Aug 16, 93 1:43 pm
Dmitry,
I'm sure someone will correct me if I am wrong, but I believe that the
manuals state that the transaction features of Access are _not_ applicable
to forms, but rather only to processing done in AccessBasic. This is something
of a major drawback, but it wouldn't be the first.
The only way I know to get true transaction processing is to handle everything
manually, which means nothing but unbound fields and a lot of code. I truly
hope someone can provide you with a better way.
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Mon, 16 Aug 1993 16:55:55 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: George Waller <HBLADM47@UCONNVM.BITNET>
Subject: Fields as rows
How can I get fields to appear as rows? Say a survey was done
and respondents answer each question with a value from 1 to 9.
Total Average
Question1 22 3.7
Question2 33 3.2
Question3 32 3.8
And, if that's not enough, how could "non-answers" be handled so
that averages would be correct. (Not all respondents answered the
question).
Thanks!
------------------------------------------------------------------------
George Waller, Microcomputer Consultant, Homer Babbidge Library U-5MS
University of Connecticut, Storrs CT 06269-1005 203-486-5260
Internet: hbladm47@uconnvm.uconn.edu Bitnet: HBLADM47@UCONNVM.BITNET
------------------------------------------------------------------------
=========================================================================
Date: Tue, 17 Aug 1993 17:22:32 +0800
Reply-To: paul@sqltech.DIALix.oz.au
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Paul Templeman <paul@SQLTECH.DIALIX.OZ.AU>
Organization: Sequel Technology
Subject: MS Access and Btrieve files
I suspect I'm asking a common question, but here goes anyway.
I've got a Btrieve based accounting system that I am using
and am trying to access the data via Access. However the
file extensions are *.btr and MS-Access is looking for files
with the extension *.ddf. I believe that the .ddf files are
data definition files which tells Access the format etc. of
the *.btr files, as the structure is not kept in the *.btr
files. Am I on the right track here ? If so my question is
can someone tell me how to create the *.ddf files. Is there
a utility to do this available via ftp or from the list server.
Any help much appreciated.
Paul...
--
Paul Templeman Sequel Technology Phone : +61 9 417 5713
Technical Director 16 Bloodwood Circle Fax : +61 9 417 7413
paul@sqltech.DIALix.oz.au South Lake 6164 Pager : +61 9 483 5822
Western Australia
=========================================================================
Date: Tue, 17 Aug 1993 08:34:05 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: SQL question
I'm developing an app in VB 3.0 (nice environment, BTW, but kind of
quirky when you're used to Access--the properties menu doesn't stay on
top, for one thing, and that's kind of a hassle--also the properties
menu doesn't quite work the same way <period>--but anyway, my SQL
question is: I'm trying to write a Search pop-up in VB that duplicates
the Search popup in Access. Did fine designing it, it works perfectly--
except that I don't know how to add in the functions for Match Case
and Search All Fields. I've been digging through the Microsoft SQL
section in the Access Language Reference but the documentation is kind
of skimpy. The Find* methods don't include this sort of functionality
and that's what I'm sort of stuck with at the moment. Any thoughts?
Actually I have a glimmer of an idea on the Search All Fields but I
shudder at writing the code...and I'd <really> like it to be more
flexible than my idea would allow it to be.
TIA,
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Tue, 17 Aug 1993 13:10:52 -0400
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Donn C Young <dyoung@MAGNUS.ACS.OHIO-STATE.EDU>
Subject: Re: ACCESS-L Digest - 15 Aug 1993 to 16 Aug 1993
In-Reply-To: <199308170401.AA10930@hp4at.eunet.co.at>
> Date: Mon, 16 Aug 1993 16:55:55 EST
> From: George Waller <HBLADM47@UCONNVM.BITNET>
> Subject: Fields as rows
>
> How can I get fields to appear as rows? Say a survey was done
> and respondents answer each question with a value from 1 to 9.
>
> Total Average
> Question1 22 3.7
> Question2 33 3.2
> Question3 32 3.8
>
> And, if that's not enough, how could "non-answers" be handled so
> that averages would be correct. (Not all respondents answered the
> question).
>
> Thanks!
>
George,
It kinda depends on how your table is defined. If it looks like:
Respondent#, Q1resp, Q2resp, Q3resp, Q4resp, ...
You can get the answers you need by just doing a Select Query and specifying
Q1resp(avg), Q1resp(sum), Q1resp(count), Q2resp(avg),... in the QBE grid. This
doesn't 'rotate' the table to give you columns as rows, but it gives you the
answers nonetheless. Note, too, that the avg [noted in the QBE Total row] and
other calculated values are based on non-null entries; if someone fails to
answer, their non-response isn't used in calculating an average - unless of
course you specified a default entry of 0 for that numeric field.
Now, if your table is defined as:
Respondent#, Question#, Response
You can generate the answer by doing a Select Query with:
Field: Question# Response Response Response
Total: Group By Sum Avg Count
Sort: Ascending
That should give you a columns as rows result.
Donn Young, OSU Cancer Center Biostatistics Unit
dyoung@magnus.acs.ohio-state.edu
=========================================================================
Date: Tue, 17 Aug 1993 14:07:17 -0600
Reply-To: jao9w265@aurora.cdev.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "John A. Olson" <jao9w265@AURORA.CDEV.COM>
In message Tue, 17 Aug 1993 17:22:32 +0800,
Paul Templeman <paul@SQLTECH.DIALIX.OZ.AU> writes:
> I suspect I'm asking a common question, but here goes anyway.
> I've got a Btrieve based accounting system that I am using
> and am trying to access the data via Access. However the
> file extensions are *.btr and MS-Access is looking for files
> with the extension *.ddf. I believe that the .ddf files are
> data definition files which tells Access the format etc. of
> the *.btr files, as the structure is not kept in the *.btr
> files. Am I on the right track here ? If so my question is
> can someone tell me how to create the *.ddf files. Is there
> a utility to do this available via ftp or from the list server.
>
> Any help much appreciated.
>
> Paul...
>
> --
> Paul Templeman Sequel Technology Phone : +61 9 417 5713
> Technical Director 16 Bloodwood Circle Fax : +61 9 417 7413
> paul@sqltech.DIALix.oz.au South Lake 6164 Pager : +61 9 483 5822
> Western Australia
>
Yes there is a utility for this. I'm not sure what it costs but I used the
copy my company had to accomplish much the same feat as you have described.
The .ddf file is indeed the data dictionary file which describes the
structure of the btrieve table(s). What you need to create is the file
named file.ddf which may already exist somewhere within your btrieve system.
If not, what I used was the btrieve command butil -stat [fileneme]
to give me an idea of what the indexes were and then I used Xtrieve to
create the dictionary definition file. I'm not sure this helps you any, but
I hope it will.
Good Luck!
John A. Olson
Computing Devices International
jao@aurora.cdev.com
=========================================================================
Date: Tue, 17 Aug 1993 21:42:43 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: tegulesseria@URSINUS.BITNET
Subject: Re: ACCESS-L Digest - 11 Aug 1993 to 13 Aug 1993
If I understand it correctly, your problem comes from having too many wind
ows open at the same time. The parent form o
nce the daughter form is opened
any problems doin
g this and the speed reduction was minimal. Oh and the way
any problems doin
=========================================================================
Date: Wed, 18 Aug 1993 06:55:00 GMT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Clare Love <0005794946@MCIMAIL.COM>
Subject: PDS What is it?
Can anyone tell me something about PDS 7.1? I assume it is some form of
database oriented development system. Please contact me directly.
Clare Love 579-4946@MCIMail.com
621 M St. Voice (206) 533-3484
Hoquiam WA 98550
=========================================================================
Date: Wed, 18 Aug 1993 11:10:55 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: John Daum at 6-6835 or 618-632-2456 <daumj@TIBERIUS.SAFB.AF.MIL>
Subject: DBMS Magazines
In-Reply-To: <9308180702.AA18238@tiberius.safb.af.mil>
Does anyone have a recommendation for a good, well rounded magazine for
databases? The perfect one would cover the popular PC DBs (Paradox,
Access, Foxpro, DBase) as well as the server DBMSs (Oracle, Sybase,
Interbase) and the challenges of standardizing, connecting, and
communicating among them all.
Thanks,
John Daum
daumj@tiberius.safb.af.mil
=========================================================================
Date: Wed, 18 Aug 1993 10:04:10 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Morris Myers <xrysta@MCODE.AMDAHL.COM>
Subject: Re: DBMS Magazines
> Does anyone have a recommendation for a good, well rounded magazine for
> databases? The perfect one would cover the popular PC DBs (Paradox,
> Access, Foxpro, DBase) as well as the server DBMSs (Oracle, Sybase,
> Interbase) and the challenges of standardizing, connecting, and
> communicating among them all.
>
> Thanks,
> John Daum
> daumj@tiberius.safb.af.mil
>
My guess is that almost everybody will have a recommendation ({->).
I subscribe to several db mags - DBMS, Database Advisor, Access Advisor,
Database and Paradox Informant. All have good points. The one that covers
the broadest base of RDBMSs is Database Advisor. Obviously, Access Advisor
covers Access in more detail as does Paradox Informant for Paradox. Database
and DBMS also cover a broad range of RDBMSs I just happen to like the depth
and style of the articles in Database Advisor.
HTH
g.mo
--
-----------------------------------------------------------------------
Morris Myers [Standard Disclaimer]
Amdahl Corporation
M/S 205 Phone: 408-746-4798
Bldg. M3 Room 311 Fax: 408-629-4374
1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com
Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us
=========================================================================
Date: Wed, 18 Aug 1993 12:44:45 -0600
Reply-To: Karen McMains <uis!mcmains@henson.cc.wwu.edu>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Karen McMains <uis!mcmains@HENSON.CC.WWU.EDU>
Subject: Duplicate record checking in Access
In-Reply-To: <9308181706.AA05078@henson.cc.wwu.edu>
Our Admissions Office hopes to use Access for our simple, but quite large,
name-and-address database of prospective students. We receive students'
names from multiple sources (phone calls, letters inquiring about our
school, college fairs, students who send us SAT/ACT scores, etc.). In
most cases we do not get their SSN, and so we have no unique identifier.
We're still using 'sneaker-net', so we must keep the central database on
one PC, enter records to diskette using many different PCs, then import the
daily entries to the central database at the end of each day and check for
duplicate records. Since we have no unique identifier we use the student's
name plus address and/or birthdate, depending on what data we have on that
student.
Of course, students often give us slightly different versions of their
names and addresses, i.e. Susie Smith, Susan Smith, S. Smith, which makes
duplicate checking even more challenging. Since we mail thousands of
recruiting pieces to these students, we must check for duplicates to reduce
costs.
We have been using PCFile5.01 for this database (groan!), and duplicate
checking was about the ONLY part of the application that worked well
under PCFile. Dup checking was a specific function and we could specify
the fields, say, last name and the first three letters of the first name.
Then PCFile would display the 'duplicates' side by side and prompt for
which record, if any, we wished to delete. Seeing the records displayed
side by side made it easy to determine if 'Susie Smith' was the same
person as 'Susan Smith'.
We don't have access to programmers, and my sophomore MIS student and
myself have been unable to find a good solution to dup checking with Access,
even after calls to Microsoft. Currently she's set up a duplicate check
using the July 1993 Smart Access tips, with the queries working on last
name concatenated with first name, but this will miss many duplicates
because first names won't always match, and there's no easy way to see
which records Access is designating as duplicates.
Can anyone suggest a workaround in Access? Alternately, can anyone
suggest databases that would meet our needs for dup checking? We like
most other features of Access and need to use the Windows environment.
THANKS!!!!!
Karen McMains
Sr. Asst. Dir./Systems & Operations
Admissions/Western Washington University
Bellingham, WA 98225-9009
mcmains@henson.cc.wwu.edu
=========================================================================
Date: Wed, 18 Aug 1993 16:25:09 MDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Comments: Converted from PROFS to RFC822 format by PUMP V2.1
From: DAVIDB <DAVIDB@NAITVM.NAIT.AB.CA>
Subject: Locating Duplicates
Question: Is there any way to have ACCESS find duplicate keys for me and then
show then to me on the screen? I am trying to clean up my tables that I have
imported from an Excell spreadsheet and I have problems. Any help would be
appreciated. Thanks in advance.
David L. Baudais, C.E.T. | Domain: DAVIDB@NAITVM.NAIT.AB.CA
Information Systems Division | "A Live mind can see a window"
CO-OP Student | "onto a world of possibilities."
N.A.I.T. |
PS: I have tried to use a query but I am not sure how to do it.
=========================================================================
Date: Wed, 18 Aug 1993 16:18:11 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: schuck@SFU.CA
Subject: Re: Locating Duplicates
In-Reply-To: <9308182302.AA23494@whistler.sfu.ca>; from "DAVIDB" at Aug 18,
93 4:25 pm
>
> Question: Is there any way to have ACCESS find duplicate keys for me and then
> show then to me on the screen? I am trying to clean up my tables that I have
> imported from an Excell spreadsheet and I have problems. Any help would be
> appreciated. Thanks in advance.
>
> David L. Baudais, C.E.T. | Domain: DAVIDB@NAITVM.NAIT.AB.CA
> Information Systems Division | "A Live mind can see a window"
> CO-OP Student | "onto a world of possibilities."
> N.A.I.T. |
>
> PS: I have tried to use a query but I am not sure how to do it.
>
One solution:
1) Add a counter field on your table. Call it key1 say.
This gives you a unique key.
2) In the query, choose your table twice.
3) Link with the key you wish to check.
4) Add any fields you need to see, plus the key1 fields from both.
5) In the criteria box under key from the 2nd table, put
>[tablename].[key1]
6) Sort on key1 of the first instance of the table.
7) run the query
You should get a list of duplicate keys with the first instance plus
all the other instances.
You can delete dups using the counter key = key1
=========================================================================
Date: Wed, 18 Aug 1993 16:56:46 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Bill Stewart <STEWART@GC.BITNET>
Subject: Re: DBMS Magazines
I'm currently receiving a magazine from the Pinncle group that is dedicated
to Access. It also comes with a disk. I think the 12 month subscription
was around $75.00. I like it because it talks about the inner working of
Access. They have quite a few articles that have been written by the
Access development team.
Let me know if you want more info
------------------------------------------------------
Bill Stewart
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date: Thu, 19 Aug 1993 06:15:25 -0400
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "John M. King" <p00756@PSILINK.COM>
Organization: KING Systems
Subject: Re: DBMS Magazines
In-Reply-To: <9308181627.AA16129@rampage.psi.net>
>DATE: Wed, 18 Aug 1993 11:10:55 -0500
>FROM: John Daum at 6-6835 or 618-632-2456 <daumj@TIBERIUS.SAFB.AF.MIL>
>
>Does anyone have a recommendation for a good, well rounded magazine for
>databases? The perfect one would cover the popular PC DBs (Paradox,
Major general ones are Data Base Advisor and DBMS. The former has more
tips and techniques. Both are available on almost all newsstands.
John King
=========================================================================
Date: Thu, 19 Aug 1993 08:16:12 -0400
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Eugene Levine <elevine@WORLD.STD.COM>
Subject: InfoWorld Reviews
In-Reply-To: <199308191051.AA12072@world.std.com>
For those who haven't seen it, the current issue of InfoWorld compares 4
programmable Windows databases (Access, Fox, Paradox and SuperBase). For
those who don't like the tester's conclusions, there's a nice Microsoft
advertisement just opposite the article :-)
Gene Levine
elevine@world.std.com
=========================================================================
Date: Thu, 19 Aug 1993 15:55:22 BST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Simon Mercer <simon@BIOCH.OX.AC.UK>
Subject: Search/Replace bug
Hi all,
In my job, I collect data from about fifty other databases, and put it
into my own (access) database. Having collected some records, I have to clean th
em up, so I use the search/replace dialogs frequently. I notice that in the
1.1 version of access, there is no way to search and replace the character ?,
because it is also a wildcard. I have tried searching for [?] (which works
in 1.0), but no luck. The MS support guy said this was a bug, so I thought I
would let you know about it.
Simon Mercer (simon@bioch.ox.ac.uk)
=========================================================================
Date: Thu, 19 Aug 1993 10:46:14 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Duplicate record checking in Access
$ From: Karen McMains, INTERNET:uis!mcmains@HENSON.CC.WWU.EDU
$ Our Admissions Office hopes to use Access for our simple, but quite large,
$ name-and-address database of prospective students. We receive students'
$ names from multiple sources (phone calls, letters inquiring about our
$ school, college fairs, students who send us SAT/ACT scores, etc.). In
$ most cases we do not get their SSN, and so we have no unique identifier.
(quick interjection: I wouldn't count on SSN as a unique identifier, no matter
what -- legally, SSN cannot be used as an identifer -- read your card)
$ We're still using 'sneaker-net', so we must keep the central database on
$ one PC, enter records to diskette using many different PCs, then import the
$ daily entries to the central database at the end of each day and check for
$ duplicate records. Since we have no unique identifier we use the student's
$ name plus address and/or birthdate, depending on what data we have on that
$ student.
$ Can anyone suggest a workaround in Access? Alternately, can anyone
$ suggest databases that would meet our needs for dup checking? We like
$ most other features of Access and need to use the Windows environment.
(I moved your final paragraph up here since it went well with the first one)
I did some thinking on this whilst taking a break from trying to write a "new"
C++ outline. I applied a little lateral thinking. (bear /c me, I'm in a strange
mood
and thinking out loud) You need a unique identifier for every potential contact
(whether
that contact is you reaching them or them reaching you), even if the contact is
someone
you already know about -- as you've found, once you have the information, it's
far
easier to delete duplicate information than gather what's missing.
Rather than find a way for all PCs to cooperate and generate a universal
identifier, why not
let each PC generate an identifer you know probably won't be generated by any
other? You
can mix and match either of these schemes:
[o] Assign a unique identifier to each PC/User/whatever and let that be the
prefix to a key
which would consist of the prefix + a counter value. The drawback to this is
you would have
to ensure each PC had a unique qualifier. Much better, but funkier, is:
[o] Assign the date/time (or even just time, but make it as detailed, even to
the second, as you
can) stamp + a counter value as the key value. What are the odds two PC will
generate the same
identifier (in this format) exactly the same? This would mean two PCs would
have to have the same
counter number at exactly the same second. Probably not very likely. Two
people on different
PCs could try and coordinate their efforts and try to break it, but they'd have
to work at it for
awhile. It's simple, easy to generate, and really doesn't have any overhead.
I don't know what your (business) political climate is, but hopefully you won't
have to try to sell
someone on schemes like this, despite the fact they do work. There seems to be
a Promethean
flaw in human nature which makes us want to put useful data in a key field, as
if that will
help the human using the information (that's what the computer is for!) (and if
I can stay up here
on my soapbox for a moment) Unfortunately, the people who propogate the need for
such things
are the ones who will fight tooth 'n nail to implement them against any form of
reasoned protest
only to see them fail. Much better to just start assigning values than to try
to make them
meaningful -- the computer doesn't care how meaningful they are and if you're
going to look
them up, why short-circuit your true efforts? I can cite many, many real-world
examples where
things like this have failed.
$ Of course, students often give us slightly different versions of their
$ names and addresses, i.e. Susie Smith, Susan Smith, S. Smith, which makes
$ duplicate checking even more challenging. Since we mail thousands of
$ recruiting pieces to these students, we must check for duplicates to reduce
$ costs.
If we could only convince direct mailing services responsible for junk mail to
do the
same thing -- any chance you could convince them to trade budgets with you? :{)
$ We have been using PCFile5.01 for this database (groan!), and duplicate
$ checking was about the ONLY part of the application that worked well
$ under PCFile. Dup checking was a specific function and we could specify
$ the fields, say, last name and the first three letters of the first name.
$ Then PCFile would display the 'duplicates' side by side and prompt for
$ which record, if any, we wished to delete. Seeing the records displayed
$ side by side made it easy to determine if 'Susie Smith' was the same
$ person as 'Susan Smith'.
This sounds like a real labour of love! (the part about PCFile 5.01)
$ We don't have access to programmers, and my sophomore MIS student and
$ myself have been unable to find a good solution to dup checking with Access,
$ even after calls to Microsoft. Currently she's set up a duplicate check
$ using the July 1993 Smart Access tips, with the queries working on last
$ name concatenated with first name, but this will miss many duplicates
$ because first names won't always match, and there's no easy way to see
$ which records Access is designating as duplicates.
This isn't a cure-all, but you could do something similar to my address book
(which is a souped-up version of the one which comes with Access): I have a
firstname, lastname, etc. etc. series of fields plus a "call me" field which is
how
they want to be addressed. If you have information on a prospective student
who filled out her standardized test under her legal name of "Susan" but likes
to
be called "Susie", this affords one extra field for matching:
If LegalName1 = LegalName2 or
CallMe1 = LegalName2 or
or or or
Anyways, just some food for thought.
P.S.
Since you are always trying to trim down your list but keep it relevant, do you
keep a
"last contact" field? That might help on mailings ("here's a list of people we
haven't
contacted or been contacted by in over a year") as well as maybe an archive or
something
so you could pare your active list periodically.
Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date: Thu, 19 Aug 1993 13:11:41 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Scott Dahne <sdahne@MAIL.LMI.ORG>
Subject: Re[2]: DBMS Magazines
I've seen the magazine. Pretty good stuff.
Scott Dahne
______________________________ Reply Separator _________________________________
Subject: Re: DBMS Magazines
Author: Microsoft Access Database Discussion List
<ACCESS-L%INDYCMS.BITNET@uga.cc.uga.edu> at INTERNET
Date: 08/19/93 01:09 PM
I'm currently receiving a magazine from the Pinncle group that is dedicated
to Access. It also comes with a disk. I think the 12 month subscription
was around $75.00. I like it because it talks about the inner working of
Access. They have quite a few articles that have been written by the
Access development team.
Let me know if you want more info
------------------------------------------------------
Bill Stewart
Gendale Community College
6000 W. Olive Ave
Glendale AZ. 85302
------------------------------------------------------
=========================================================================
Date: Thu, 19 Aug 1993 13:14:00 LCL
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: MKRO <MKRO.DIS-PC@BMAILIN.ITG.TI.COM>
Subject: Pop-up Calender in Access
Has anyone tried to provide a Pop-up Calender in an ACCESS application?
I am looking for a "Spiffy" solution to providing a user with the ability to
pop up a graphical calender
which defaults to a specified date, and allows them to view a month at a
time. This would give them the
ability to realize when weekends and holidays may conflict with a shipping
date. They would then be able to pick a date and that date be entered into a
field on a ACCESS table(shipping day) and the
popup calendar disappear.
I have considered picking apart the calendar from the "CMS" application on
the MS ACCESS companion diskett, but that seems to tedious and does not look
to impresive.
Is there someway to pass information to and from an existing Windows app like
the Calendar, through
an API call?
Any suggestions?
=========================================================================
Date: Thu, 19 Aug 1993 14:29:55 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Pop-up Calender in Access
In-Reply-To: Message of Thu,
19 Aug 1993 13:14:00 LCL from <MKRO.DIS-PC@BMAILIN .ITG.TI.COM>
You can call the Windows Calendar applet with a macro...try a RunApp
command pointing to Calendar.
Sendkeys
Keystrokes: {F9}
Wait: No
RunApp
Command Line: Calendar
This starts the Calendar and puts it into the Month mode (rather than
the daily appointment mode, which it defaults to without the SendKeys
statement). Tie that macro to a command button and you've got a pop-up
calendar.
HTH
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Thu, 19 Aug 1993 14:35:34 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Pop-up Calender in Access
In-Reply-To: Message of Thu,
19 Aug 1993 13:14:00 LCL from <MKRO.DIS-PC@BMAILIN .ITG.TI.COM>
Sorry, wasn't paying attention...whether or not you can pull in the date
is another matter. You might take a look at the AppActivate statement
in the Language Reference--it calls the Calculator, performs some calculations,
and then displays the result. That might give you some clues.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Thu, 19 Aug 1993 15:36:52 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Pop-up Calender in Access
% I have considered picking apart the calendar from the "CMS" application on
% the MS ACCESS companion diskett, but that seems to tedious and does not look
% to impresive.
% Is there someway to pass information to and from an existing Windows app like
% the Calendar, through
% an API call?
% Any suggestions?
I'd suggest just writing one -- not that difficult, especially since the day of
week routines are built-in (and
even if they weren't I could supply you with some of the shortest DOW,
julian<->gregorian, etc. code you've
probably ever seen)
I remember getting bored years ago and writing calendars in low-level
spreadsheets -- it should be pretty
easy with all of the tools provided...
=========================================================================
Date: Thu, 19 Aug 1993 15:38:37 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Shameless Plug enclosed
I debated plugging something I've worked on and decided the benefit to the
reading audience
was more important than other things. Besides, I did put a warning on the
subject.
"Access 1.1 Developer's Guide" by Roger Jennings (SAMS/Prentice Hall
Computer Publishing)
(ISBN 0-672-30178-4) should begin appearing on the shelves within the next
few days.
This book is by a developer for developers. It does not attempt to teach
Access but addresses problems, solutions, methodologies, and issues
concerning those persons who wish to develop solid, polished applications,
whether it be for personal use or for distribution (so obviously ADK issues
are dealt with).
Anyone who has developed an application for use by others knows how
difficult it can be simply because when you run your (own) applications,
you already know how to use it -- you don't have to worry about lots of
little things users seem to unravel for you. Those issues are the
foundation of this book. At $39.95 for nearly 1200 pages, you won't find
yourself skipping the first section or half because you already know Access
-- the entire book is of benefit to the development community! (whether it
be how to write wizards, solid ABC, ODBC, help files, etc.)
As a former longtime systems programmer and consultant, the highest praise
I can pay this book is "if I didn't work here, I'd buy it."
Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
CARmel, Indiana (carMEL is in California)
=========================================================================
Date: Thu, 19 Aug 1993 15:16:52 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Shameless Plug enclosed
In-Reply-To: Message of Thu,
19 Aug 1993 15:38:37 EDT from <72410.2162@COMPUSER VE.COM>
Phil, <I'd> judge that plug to be OK. The list is here for the exchange
of information, including info on current books. If it was a blind post
from someone off the list, I'd say otherwise. A gentle plug of something
you've worked on that happens to <be> a commercial product when you are
a contributing member of the list is another story. You know the product
and are offering your information in the form of a review. Works for me...
Out-and-out solicitation to purchase is definitely against BITNET/CREN
guidelines, however. (Not aimed at Phil, just making the general
observation for the good of the cause...)
Sounds like an interesting book! I will give it a look. Always patronize
your local publishers, I say...:)
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Thu, 19 Aug 1993 13:24:23 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Re: Shameless Plug enclosed
In-Reply-To: <9308192018.AA10172@hermes.intel.com>; from "Phil Paxton" at Aug
19, 93 3:38 pm
> I debated plugging something I've worked on and decided the benefit to the
> reading audience
> was more important than other things. Besides, I did put a warning on the
> subject.
I would agree that the benefit outweighs any other ethical problems. Thank
you for posting about the book. Questions:
1. Any chance Microsoft will be selling the book? I understand they resell
a number of books written for their products. I think we get a discount
from MS, which is why I ask.
2. What is the fastest way to get the book otherwise? Can you tell I'm
excited about it? Sounds like just what we've been asking for.
Thanks again.
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Fri, 20 Aug 1993 14:13:00 +01
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Nilsson Jimmy, HK/R IDE" <Jimmy.Nilsson@IDE.HK-R.SE>
Subject: Replication of databases
Hi!
----
I have a problem (which I think is pretty usual). I want to make it possible
to use a database in the same way as you can use Lotus Notes, but I want to
make it with an Access database. The functionality I want is the replication
of data so that many people can work with the same database without having
to beeing online all the time.
Do You know anybody who has solved this problem? Is there any product to
buy?
Please help me!
--Regards
----Jimmy Nilsson
--------University of Karlskrona/Ronneby, Sweden
###
=========================================================================
Date: Fri, 20 Aug 1993 10:26:02 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Scott Dahne <sdahne@MAIL.LMI.ORG>
Subject: Access vs. Visual Basic 3.0
Does anyone have any feelings on the use of Access versus Visual basic
3.0 now that VB has the Access engine embedded?
=========================================================================
Date: Fri, 20 Aug 1993 10:38:35 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Access vs. Visual Basic 3.0
% Does anyone have any feelings on the use of Access versus Visual basic
% 3.0 now that VB has the Access engine embedded?
Well, the VB3.0 docs aren't very definitive about this or OLE 2.0 support -- I
do know of a couple of
solutions in the works... ;{)
Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date: Fri, 20 Aug 1993 19:38:26 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Jeffrey Young <Jeffrey=Young%SQA%Banyan@MAGNOLIA.BANYAN.COM>
I am a new user of Access and have a couple questions that are probably
pretty basic, but are driving me bonkers.
I have created a table, and a query of that table, and a form of that query.
I use the form to input data to the source table with some fields using the
pull-down menu features. I would like to have selected fields displayed in
the form to "carry" the value from the previous form as their default value.
I know I can pull in this data manually if I enter Cntrl-" at these fields.
But doing that for every field I want to carry data to is a real pain, not to
mention rather awkward for the user. I have used Aston Tate's dBase IV and
you can assign this carry function as a field attribute in the FORM design.
Can Access do the same somehow?
Also I would like to have those fields that are DATE format, and that do not
have a value yet defined in them, to have today's date assigned to this field
if they are clicked on or selected somehow. Is this possible?
Thanks in advance for the help!
jeff young
jyoung@banyan.com
=========================================================================
Date: Sat, 21 Aug 1993 14:10:38 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Scott Dahne <sdahne@MAIL.LMI.ORG>
Subject: Re: No subject given
To carry fields:
create a text box on the second from with the source as
=forms![form name]![control] where form name is the name of the first
form and control is the name of the field on that first form
containing the variable you want to pass.
Scott Dahne
sdahne@lmi.org
______________________________ Reply Separator _________________________________
Subject: No subject given
Author: Microsoft Access Database Discussion List
<ACCESS-L%INDYCMS.BITNET@uga.cc.uga.edu> at INTERNET
Date: 08/20/93 07:44 PM
I am a new user of Access and have a couple questions that are probably
pretty basic, but are driving me bonkers.
I have created a table, and a query of that table, and a form of that query.
I use the form to input data to the source table with some fields using the
pull-down menu features. I would like to have selected fields displayed in
the form to "carry" the value from the previous form as their default value.
I know I can pull in this data manually if I enter Cntrl-" at these fields.
But doing that for every field I want to carry data to is a real pain, not to
mention rather awkward for the user. I have used Aston Tate's dBase IV and
you can assign this carry function as a field attribute in the FORM design.
Can Access do the same somehow?
Also I would like to have those fields that are DATE format, and that do not
have a value yet defined in them, to have today's date assigned to this field
if they are clicked on or selected somehow. Is this possible?
Thanks in advance for the help!
jeff young
jyoung@banyan.com
=========================================================================
Date: Sat, 21 Aug 1993 22:14:15 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Greg Fairnak <GFAIRNA@AMERICAN.EDU>
Organization: The American University
Subject: Re: Pop-up Calender in Access
In-Reply-To: Message of Thu,
19 Aug 1993 13:14:00 LCL from <MKRO.DIS-PC@BMAILIN.ITG.TI.COM>
Pop up calender????
Maybe get a copy of scheduler (MS) and use DDE. Check developers CD ROM or
technet for free copy.
I think the NT CDROM release has the source for applettes(calendar) on the disk
G
=========================================================================
Date: Sat, 21 Aug 1993 22:23:20 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Greg Fairnak <GFAIRNA@AMERICAN.EDU>
Organization: The American University
Subject: Re: Access vs. Visual Basic 3.0
In-Reply-To: Message of Fri,
20 Aug 1993 10:26:02 EST from <sdahne@MAIL.LMI.ORG>
Faster to develop apps and produce reports using Access. Some VBers seem
to dislike crystal reports. You could say access is more data aware.
G
=========================================================================
Date: Sat, 21 Aug 1993 21:41:32 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Access vs. Visual Basic 3.0
In-Reply-To: Message of Sat,
21 Aug 1993 22:23:20 EDT from <GFAIRNA@AMERICAN.ED U>
Access is a <lot> more data aware than VB. VB is also missing some key
elements of the Access engine (at least in my opinion)--particularly
the FindRecord method (as opposed to FindFirst, FindNext, etc.) which
allows you to match case, search as formatted, and search all fields
just by specifying the proper options. It happens that I need that
functionality for an app I'm writing and it just isn't there in VB.
I dislike Crystal Reports immensely. This is mostly because it uses
its own syntax for record selection instead of MS SQL, which would be
a better choice considering that the Access engine already accepts
the SQL syntax. I wrote that on my Crystal Reports registration form
when I sent it in. The other thing I dislike about Crystal Reports
that I just discovered today is that it does not support automatic
formatting of dot matrix mailing label formats (unless I'm missing
something). The flip side is that it's functional and beats the heck
out of trying to format reports in code. It's just not as easy to
use as the Access report engine. (And I never thought I'd say anything
nice about the Access report engine, either, other than the fact that
it beats the heck out of the dBase way of doing things.)
At $199 list for the VB 3.0 upgrade for MS Access registered users,
I felt (and feel) that it was more cost effective for me to purchase
VB rather than the ADK to develop stand-alone Access applications.
If MS would get that FindRecord method installed and do something
toward making Access-developed reports out of the .MDB visible to
VB, it would be an <awfully> nice package. (BTW, I can't get VB to
pull queries out of the .MDB, either, unless I specify the query
name by typing it into the RecordSource property setting of the
data control. Queries, unlike tables, do not show up in the pull-
down list box. Why??????)
There are some quirks in VB that Access users will be uncomfortable
with at first. As noted, the controls are by and large not data-aware.
I have coped with the problem of option groups not being data-aware
by tying them to hidden text boxes on the form and executing code in
click events to change the underlying data. There may be other ways
of doing this but this was the workaround I discovered.
Another thing that bothers me is that the property window doesn't stay
on top. I get extremely tired of popping it back up every time I jump
back into the form to highlight a different control. It is extremely
clear to me that two different development teams were at work on the
two different products--it is not a seamless transition as I think I
led myself to believe. :)
VB is extremely versatile and I hope to use it a lot to develop stand-
alone products. I will continue to do the bulk of my MAJOR database
development in Access. It's a case of picking the right tool for the
job, and I would not be likely to use VB for a major DBMS project unless
a future version were more data-aware and more Access-aware. I hope the
MS folks listening in will pass this along to the VB team. At least
tell them to include FindRecord next time!!!! :)
Oh, one other thing--the help compiler. Everything is there except the
Help Project Editor. This doesn't make much sense to me, as it means you
have to code your help project files (the .hpj file that the compiler uses)
by hand. I've been using the Windows Help Authoring Templates (WHAT)
and the files that come with it, including WHPE.EXE, the Help Project
Editor, and it makes life MUCH easier. (WHAT and HAG, the help authoring
authoring guide, are both available on CICA, by the way.) It just doesn't
make any sense to me that VB shipped with the Help Compiler but not the
Help Project Editor. Aieee...well, maybe that's why my name isn't Bill
Gates...I don't have the high level approach. :)
This LONG posting got out of hand on a list that should be focused on
Access. I've been bad...please excuse. I should know better, right? :)
Oh, BTW, there <is> a Visual Basic list if anyone is interested--it's
VISBAS-L@TAMVM1.BITNET. It's EXTREMELY active...daily digests have
been running 1000-1500 lines. Enjoy...
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Sun, 22 Aug 1993 06:59:31 -0600
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: richard dixon <richard.dixon@M.CC.UTAH.EDU>
Subject: Re: Access vs. Visual Basic 3.0
In-Reply-To: <F0B95E1C88008432@CC.UTAH.EDU>
Thanks to Nathan and everyone for the Access vs. VB 3.0 thread (among
other things). It was (is) very informative. I raised these questions on my
initial mailing to the list and am gratified to learn more about the
distinctions between the two products.
I am still perplexed by the fact that The Kit is needed to distribute
Access but VB is royalty-free out of the box. Essentially, if the two are
used to create a single app, a third (the Kit) is still needed for
distribution, even though VB distribution is royalty-free.
Anyone have any ideas why VB would be free and Access would need the kit?
What is MS thinking? Will The Kit need to be upgraded as MS makes major
upgrades to Access? Just curious.
Thanks,
Richard
=========================================================================
Date: Sun, 22 Aug 1993 10:36:47 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Access vs. Visual Basic 3.0
In-Reply-To: Message of Sun,
22 Aug 1993 06:59:31 -0600 from <richard.dixon@M.C C.UTAH.EDU>
Just as a wild fling in the dark...DBMS compilers that produce stand-alone
programs have always been insanely expensive (going back to what I know
about dBase--seems to me that the runtime compiler for dBase IV 1.0 listed
somewhere between $450 and $600), while straight language compilers such
as QuickBasic, QuickC, and the Borland products (I think) have always
included the royalty-free distribution biz. I do NOT know why this is,
excepting only the thought that Ashton-Tate (now Borland), for instance,
was more interested in people buying the whole shebang (dBase in any of
its myriad versions) and paying the insanely high price for THAT rather
than essentially saying, go ahead, develop cheap database stand-alones
and we'll just sit back and smile while we lose our shirts. In VB or
Access, everyone can be a programmer. This is not necessarily true of
dBase...but if you <have> dBase, and use the Assist menu, you can do
most things without writing a line of code. On the other hand, if
this is a marketing strategy aimed at having millions of copies of
dBase IV in the hands of people who won't even scratch the surface
of what it's capable of, why is the list price so damn high?????
As to why Microsoft has abandoned its long-time royalty-free attitude
and NOT included a compiler with Access, I have absolutely no idea...
but I can't afford both VB and the ADK and I need VB for other reasons.
Result: MS can scratch one ADK sale until the price comes down or they
wake up and include the compiler with Access at the same price. (BTW,
now that the introductory period is over, have you <seen> the list price
on Access 1.1? Yow!) I would point to the same "argument" I think
A-T/Borland uses to justify making a developer's kit optional and as
much or more expensive than the DBMS product itself...but then I wonder
who the split personality was who decided a royalty-free runtime Access
engine (somewhat crippled, as I detailed earlier, but still an Access
engine) should come included with VB 3.0 but separately (with full
functionality) and at a steep price for Access itself. Don't get me
wrong--I'd LOVE to have a copy of the ADK.
One thing I neglected to mention in my last post as a weakness (in my
view) in VB 3.0--as a VB/DOS 1.0 user, I use the ISAM files created
with the PROISAMD TSR. Why doesn't Access recognize this format (and
as a corollary, why doesn't VB 3.0 recognize this format)? It would
be awfully nice to be able to use that data in both environments without
having to convert the ISAM to a comma-delimited or tab-delimited format
first. I was mightily surprised and disappointed when Access 1.0 flatly
dismissed the ISAM format (and imports Btrieve, dBase, Fox, etc., of which
I use only dBase). And ANOTHER thing...why doesn't MS just INCLUDE the
ISAM commands in the interpreter in both the PDS and VB/DOS? That TSR
is a pain in the ... well, you know. :)
Maybe I'm missing something...I don't know. Maybe Access 2.0 will have
a compiler like VB????? (And no Crystal Reports???) :)
There are many issues here that are barely related to Access and again
I apologize...but it would be nice if the development teams at MS
talked to each other and tried to find ways for their applications
to live with one another. Windows itself has provided much of this
sort of functionality, OLE has done the same, but down at the gut
level we're talking about, data formats should have something in
common (or at least, the various products should know about each
other's special formats). *30* for now.
I encourage folks to jump in with this sort of give-and-take so long as
no one writes me complaining about it. I think cross-platform information
sharing in this crazy DBMS world is important and that's one of the
reasons this list is here.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Mon, 23 Aug 1993 10:04:12 +0100
Reply-To: focke@gmd.de
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Comments: Warning -- original Sender: tag was Stefan.Focke@GMD.DE
From: Stefan Focke <focke@GMD.DE>
Subject: How to change a query a form is based on?
Hello!
I would like to change a query a form is based on while the form is active.
That is what I have:
- I have a form with a button and a subform
- The subform is based on a query "myquery"
- With the button I activate a Access Basic program that uses
DeleteQueryDef and CreateQueryDef to change the query "myquery"
My problem:
- The only way to activate the changed query is to close the form and open
it again.
- I would like to have something Requery that rereads the Query
Thank you
Stefan Focke
----------------------------------------------------------------------
Stefan Focke Tel. 02241-14-3154
GMD-ISA e-mail: focke@gmd.de
Rathausalle 10
D-W 5205 Sankt Augustin 1
********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date: Mon, 23 Aug 1993 10:21:27 +0100
Reply-To: focke@gmd.de
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Comments: Warning -- original Sender: tag was Stefan.Focke@GMD.DE
From: Stefan Focke <focke@GMD.DE>
Subject: Access Animation Screen
Hello!
How to start the Access animation screen:
- Create a new database
- Create a table with one row
- Save it as Cirrus
- Select Help|Info
- Press <Shift> <Ctrl>
- Doubleclick the key-symbol with the right mouse button
- now it starts
- speed it up by clicking with the left mouse-button
This works with the german version 1.1. Maybe it also works for you.
Stefan
----------------------------------------------------------------------
Stefan Focke Tel. 02241-14-3154
GMD-ISA e-mail: focke@gmd.de
Rathausalle 10
D-W 5205 Sankt Augustin 1
********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date: Mon, 23 Aug 1993 06:00:52 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Morris Myers <xrysta@MCODE.AMDAHL.COM>
Subject: Re: Access vs. Visual Basic 3.0
>
> ... and disappointed when Access 1.0 flatly
> dismissed the ISAM format (and imports Btrieve, dBase, Fox, etc., of which
> I use only dBase).
I was equally disappointed that MS did not choose to use the Paradox 4.0
database format as one of the types that they would import. It makes it
difficult for us bilingual folks to use Access with existing Paradox 4.0
applications. (A whole new market could open for MS! {:->).
>
> ...I don't know. Maybe Access 2.0 will have
> a compiler like VB????? (And no Crystal Reports???) :)
>
I'll vote for that kind of improvement!!
> There are many issues here that are barely related to Access and again
> I apologize
Please don't apologize for expressing such good ideas. After all, isn't a
list like this for exchange of ideas! :-)... Those ideas don't have to be just
technical or problematic.
> ...but it would be nice if the development teams at MS
> talked to each other and tried to find ways for their applications
> to live with one another.
Alas, a problem shared by TOO many PC development houses. MS talks like
they pride themselves on their inter-project communications but it looks
like they missed a bit with Access and VB 3.0.
Thanks for the thoughts, nathan ...
g.mo
--
-----------------------------------------------------------------------
Morris Myers [Standard Disclaimer]
Amdahl Corporation
M/S 205 Phone: 408-746-4798
Bldg. M3 Room 311 Fax: 408-629-4374
1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com
Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us
=========================================================================
Date: Mon, 23 Aug 1993 09:11:01 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Re: Access Animation Screen
> Hello!
>
> How to start the Access animation screen:
>
> - Create a new database
> - Create a table with one row
> - Save it as Cirrus
> - Select Help|Info
> - Press <Shift> <Ctrl>
> - Doubleclick the key-symbol with the right mouse button
> - now it starts
>
> - speed it up by clicking with the left mouse-button
>
>
> This works with the german version 1.1. Maybe it also works for you.
Works great with the US version as well. Not one of the more exciting
animations I've seen, though. So, what is the significance of the two
ducks being destroyed? Usually such an animation is some sort of sneaky
reference to the competition, such as with the animation screen in
Microsoft Word, where there is a reference to WordPerfect. Any clues?
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Mon, 23 Aug 1993 13:16:00 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Skewes-Cox, Tom" <tskewes@SAONET.UCLA.EDU>
Subject: Re: Access Animation Screen
| > How to start the Access animation screen:
| >
| > - Create a new database
| > - Create a table with one row
| > - Save it as Cirrus
| > - Select Help|Info
| > - Press <Shift> <Ctrl>
| > - Doubleclick the key-symbol with the right mouse button
| > - now it starts
| >
| > - speed it up by clicking with the left mouse-button
| >
| >
| > This works with the german version 1.1. Maybe it also works for you.
|
| Works great with the US version as well. Not one of the more exciting
| animations I've seen, though. So, what is the significance of the two
| ducks being destroyed? Usually such an animation is some sort of sneaky
| reference to the competition, such as with the animation screen in
| Microsoft Word, where there is a reference to WordPerfect. Any clues?
|
| --
Destroying a "Pair of ducks" Sneaky enough I think ;)
=========================================================================
Date: Mon, 23 Aug 1993 16:38:02 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Access Animation Screen
% | Works great with the US version as well. Not one of the more exciting
% | animations I've seen, though. So, what is the significance of the two
% | ducks being destroyed? Usually such an animation is some sort of sneaky
% | reference to the competition, such as with the animation screen in
% | Microsoft Word, where there is a reference to WordPerfect. Any clues?
% |
% | --
% Destroying a "Pair of ducks" Sneaky enough I think ;)
Even more sneaky than you think. What do you think the icon was during the
Paradox beta?
Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date: Tue, 24 Aug 1993 07:40:00 +01
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Nilsson Jimmy, HK/R IDE" <Jimmy.Nilsson@IDE.HK-R.SE>
Subject: SV: Re: Replication of databases
Do you have any ideas on your own? Perhaps you are interested in making an
objekt-oriented model together with me? That would be a good start I think.
Then I hope some other would like to help too.
C U
Jimmy Nilsson, University of Karlskrona/Ronneby, Sweden
Jimmy.Nilsson@ide.hk-r.se
###
----------
Fran: owner-visbas-l
Till: Multiple recipients of list VISBAS-L
Angaende: Re: Replication of databases
Datum: fredag 20 augusti 1993 12.43
I just asked a question like this to the foxpro list.
no responses yet.
=========================================================================
Date: Tue, 24 Aug 1993 08:30:03 CDT
Reply-To: tntow@timtow.b1.ingr.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Tim Tow <tntow@TIMTOW.B1.INGR.COM>
Subject: NetDDE with Access as a Server
Has anyone successfully used NetDDE with Access as a server? I have an Excel
app that uses DDE with the "SQL" topic to run dynamically prepared SQL
statements (that return a boolean, ie is an account number valid..)... I would
like to migrate this to a network environment but have not had success...
I think I have defined the DDE Shares correctly and actually get a channel
number, however, when I try to retrieve the data, I get an error which seems
to indicate the channel number is invalid.
If anyone has done this successfully, please contact me via email.. I will
post a summary to this list...
Thanks..
----------------------------------------------------------------------------
Tim Tow, CPA Phone: 205-730-8234
Intergraph Corporation Fax: 205-730-2164
Mailstop: HQ011 Mailpath: tntow@ingr.com
Huntsville, AL 35894-0001
=========================================================================
Date: Tue, 24 Aug 1993 11:04:42 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Steve Bratten <GE0793@SIUCVMB.BITNET>
Subject: Hidden animation in MS programs...
Thanks for the information on accessing the animation in Access. Now, I
have two brief questions:
1) Is the primary difference between the standard and professional
versions of Visual Basic the ability to distribute applications without
royalties?
2) How do we see the animation in MS Word (2.0c)?
^^^^^^^^^Steve Bratten^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| _ o__ |
| ( \ _/_ _.>/^_ BITNET < GE0793@SIUCVMB > |
| \ / _ _ _ (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > |
| \_) (__(/_/(_/\_(/_ |
| __ \o \o \o Graduate School |
| |__) __ __ -/-/-_ __ |> |> |> Southern Illinois University |
| |__) / (_(_/(_/`/_(/_/// < \ < \ < \ Carbondale, IL 62901-4716 |
| |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date: Tue, 24 Aug 1993 13:42:15 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Hidden animation in MS programs...
%Thanks for the information on accessing the animation in Access. Now, I
%have two brief questions:
I'm surprised there was anyone left who hadn't seen it...BTW, those are usually
called "Easter Eggs"
% 2) How do we see the animation in MS Word (2.0c)?
"Feed a man a fish, he's full today, teach a man to fish, he's full forever."
(Chinese Proverb)
Extract the following code and send it to
LISTSERV@UIUCVMD.CSO.UIUC.EDU
You'll get the answer to your question and many other Easter Egg questions...
--------------------------------------------------------------------------------
----------
//Looking JOB Echo=YES,Reply-via=MAIL
Database search DD=Mine
//Mine DD *
Search EASTER EGG in WIN3-L
index
PRINT ALL
--------------------------------------------------------------------------------
----------
=========================================================================
Date: Tue, 24 Aug 1993 13:07:44 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Jon Diercks <jon@ANDERSON.EDU>
Subject: Re: Access Animation Screen
In-Reply-To: from "Skewes-Cox, Tom" at Aug 23, 93 1:16 pm
Did you all happen to notice the very last name in the "Special Thanks To"
section? It's a name we should all be familiar with!
--
\on \ jon@anderson.edu Administrative Systems
\_\ <_\iercks Anderson University
> Anderson, IN
--- ...Life is too important to be taken seriously.
=========================================================================
Date: Tue, 24 Aug 1993 13:33:20 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Access Animation Screen
In-Reply-To: Message of Tue, 24 Aug 1993 13:07:44 EST from <jon@ANDERSON.EDU>
Well shucks. I guess I'm just going to have to get off my duff and
send my $20 to MS for Access 1.1. You guys are having all the fun!
:)
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Tue, 24 Aug 1993 13:38:52 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Jon Diercks <jon@ANDERSON.EDU>
Subject: Re: Access Animation Screen
In-Reply-To: from "Nathan Brindle" at Aug 24, 93 1:33 pm
> Well shucks. I guess I'm just going to have to get off my duff and
> send my $20 to MS for Access 1.1. You guys are having all the fun!
... the animation screen works in 1.0 too. try it!
--
\on \ jon@anderson.edu Administrative Systems
\_\ <_\iercks Anderson University
> Anderson, IN
--- ...Life is too important to be taken seriously.
=========================================================================
Date: Tue, 24 Aug 1993 17:02:12 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Access Animation Screen
In-Reply-To: Message of Tue, 24 Aug 1993 13:38:52 EST from <jon@ANDERSON.EDU>
Hmm ... I did. It didn't work. Maybe I did something wrong. I'll try
it again! Thanks! :)
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Tue, 24 Aug 1993 23:37:44 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phillip Paxton <72410.2162@COMPUSERVE.COM>
Subject: Algorithms
Because of so many requests, I'm reprinting the algorithms for Day of Week,
Julian->Gregorian, and Gregorian->Julian, as well as a Leap Year function
which returns an integer value depending upon whether the specified year is
a Leap Year. Remember, a Leap Year is any year not ending in 00 divisible
by
four, or any century (ending in 00) year which is divisible by 400. This
means 1800 and 1900 are not Leap Years, but 2000 is.
The mathematics are all mine, derived from before I ever had access to a
calculator, let alone a computer (mostly from going to grad school with my
mum when I was ten or eleven and needing something to do when they were
taking their tests).
Whilst discovered independently, my DOW routine is very, very similar to
Zoeller's congruence, but I didn't know that when I put the numbers
together. There is also an alternative method which derives the same
numbers, but is easier to do as a bar trick (long story). The source is
REXX, so if you aren't familiar
with REXX, it should still be readable and portable to other programming
platforms, but you should know that the percent sign (%) represents integer
division and double slash (//) represents the modulo function (aka
remainder for those who failed mathematics).
I'm offering these for your enjoyment. These are protected from commercial
exploitation via print copyright (a real one, not fiat) so I'm requesting
[that] if you use them in a commercial endeavour, you mention who gave it
to you. Just remember, I can prove I understand the math, so if you betray
me, you may be pressed
upon to do the same! (be forewarned -- I'm Evariste Galois reincarnated!!!)
I also carry algorithms for Easter and basedate (from Computer Language
magazine), non-recursive: repeating permutations, non-repeating
permutations, combinations (far easier than many you'll see in magazines),
wind chill, relative humidity, computing roots of any degree by an
alternative, averaging method, and a method of computing prime factors
which isn't in print anywhere else yet, but has been confirmed as
practical, as well as tips about doing things like GCF and LCD.
Enjoy.
Phillip Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
------------------------------------------------------------------------
------------------------------------------------------------------------
Alternative Method for day-of-week computations:
Last Two Digits of the Year: 93
Divide by Four (ignore remainder): 23
Add Day of Month: 24
Month Offset (see below): 3
-------------------------------------------
Total (add): 143
Divide by 7 20
Remainder: 3
Sun=1, Mon=2, Tue=3, Wed=4, Thu=5, Fri=6, Sat=0
August 24, 1993 is a Tuesday.
Month Codes:
Jan=1 Apr=0 Jul=0 Oct=1
Feb=4 May=2 Aug=3 Nov=4
Mar=4 Jun=5 Sep=6 Dec=6
During Leap Years, use Jan=0, and Feb=3.
------------------------------------------------------------------------
/* DOW (Day of Week) Routine */
/* Source: original algorithm by Phillip Paxton */
arg month day year .
weekday.0 = 'Sunday'; weekday.1 = 'Monday';
weekday.2 = 'Tuesday'; weekday.3 = 'Wednesday';
weekday.4 = 'Thursday'; weekday.5 = 'Friday';
weekday.6 = 'Saturday';
call leapyr year; leapyear = result; /* get leapyear value */
ld = year // 100; /* get the last two digits of the year */
m1 = (month + 9) // 12 + 1; /* make jan 11, feb 12, mar 1, apr 2, ... */
m2 = m1 // 11;
m2 = trunc( 0.8 * ( 2 * m2 + 1 ) + m2 ); /* month offset to jan 1 */
m2 = m2 - ( leapyear * ( m1 % 11 ) ); /* correct for leapyear */
w = ( ld + ld%4 + day + m2 ) // 7; /* determine day of the week */
say month'/'day'/'year 'is/was/will be a' weekday.w;
exit;
------------------------------------------------------------------------
/* JULIAN Routine (convert Gregorian to Julian) */
arg month day year .
call leapyr year; leapyear = result /* determine leap year value */
jul = trunc( (month + 2) * 30.55 ) + day - 91
if ( jul > 60 )
then jul = jul - 2 + leapyear;
say 'The Julian date for' month'/'day'/'year 'is' jul'.'year
------------------------------------------------------------------------
/* GREGORIAN routine (convert julian to gregorian) */
/* Source: original algorithm by Phillip Paxton */
arg jul year .;
day = jul;
call leapyr year; leapyear = result; /* determine leapyear value */
if ( day > ( 59 + leapyear ) ) then day = day + 2 - leapyear;
day = day + 91;
month = day % 30.55;
day = day - trunc(month * 30.55);
month = month - 2;
say 'The Gregorian date for' jul'/'year 'is' month'/'day'/'year;
-----------------------------------------------------------------------
/* LEAPYR EXEC - is it a leap year? 1=yes; 0=no */
/* will handle 2 or 4 digit year; assumes current century if 2 digit */
arg year;
cc = year % 100;
if cc = 0 then cc = substr( date(SORTED), 1, 2 );
yy = year // 100; /* last 2 digits year */
if yy % 4 ^= 0 then leap = 0;
else do;
if ( (yy = 0) & (cc % 4 = 0 ) ) | ( yy ^= 0) then leap = 1;
else leap = 0;
end; /* else */
return( leap );
-----------------------------------------------------------------------
<end of message>
=========================================================================
Date: Wed, 25 Aug 1993 14:20:25 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: NCLCHAN@NTUVAX.BITNET
Subject: Attach Oracle table
I tried to attach Oracle table to Microsoft Access datafile file in
Microsoft Access 1.1. I noticed that once I attached the Oracle tables ( after
closing Attach Table Dialog Box ), I no longer could attach any Oracle tables.
Error Message - ODBC Call fails.
Has anyone out there ever encountered something like that ? How do you solve the
problem ?
By the way, I know that I can attach the Oracle tables if I quit Microsoft Windo
ws and go in again. But tedious , isn't it ?
Chor Ling
NCLCHAN@NTUVAX.NTU.AC.SG
=========================================================================
Date: Wed, 25 Aug 1993 14:24:09 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: NCLCHAN@NTUVAX.BITNET
Subject: Editing Attached Oracle Table
Has anyone out there edited attached Oracle Table in Microsoft Access 1.1.
??
I tried to edit but the attached Oracle Table is read-only.
Any advice ?
Chor LIng
NCLCHAN@NTUVAX.NTU.AC.SG
=========================================================================
Date: Wed, 25 Aug 1993 16:22:14 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: NCLCHAN@NTUVAX.BITNET
Subject: Re: Attaching Oracle Table
I have solved the problem. I tried to attach in another PC and it works.
I guess Oracle doesn't like my PC ;-). Anyway, please forget my Question.
Chor Ling
=========================================================================
Date: Wed, 25 Aug 1993 16:23:24 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: NCLCHAN@NTUVAX.BITNET
Subject: Re: Editing Oracle Table
I solved the problem by creating a primary key. Please forget my Question.
Chor Ling
=========================================================================
Date: Wed, 25 Aug 1993 11:02:58 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Scott Dahne <sdahne@MAIL.LMI.ORG>
Subject: Output of job "Easter Egg Hunt"
I received the following message:
---------------------------------------------------------------------------
Subject: Output of your job "Looking"
Author: BITNET list server at UIUCVMD (1.7f) <LISTSERV@VMD.CSO.UIUC.EDU>
Date: 08/25/93 10:45 AM
Job "Looking" started on 25 Aug 1993 09:07:39
Job "Looking" ended on 25 Aug 1993 09:07:39
Summary of resource utilization
-------------------------------
CPU time: 0.001 sec Device I/O: 0 Overhead CPU:
0.002 sec Paging I/O: 0 CPU model: 3081
DASD model: 3380
----------------------------------------------------------------------------
when trying to get the easter eggs using a message that looked like:
//Looking JOB Echo=YES,Reply-via=MAIL Database search DD=Mine //Mine DD *
Search EASTER EGG in WIN3-L
index
PRINT ALL
Any ideas on what happened?
Scott Dahne
sdahne@lmi.org
=========================================================================
Date: Wed, 25 Aug 1993 09:55:24 CDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Chet Farmer <CFARMER1@UA1VM.BITNET>
Organization: Project IDEALS -- The University of Alabama
Subject: Automatic field updates
In-Reply-To: Message of Wed, 25 Aug 1993 16:23:24 +0800 from <NCLCHAN@NTUVAX>
I've a question, and I'm hoping somebody can help out.
I have a largish database of names and addresses (just under 2k records).
For convenience's sake, I include a field for both Country AND Country-in-
French. I also include a field for the country telephone code (eg, 44 for
England).
My question is this. Is there an easy way to have the French-country and
country-code fields filled automatically in the primary table/data entry
form given an entry in the regular-country field AND another table with
each country's corresponding French name and telephone code?
For example: I enter John Doe into the database. When I get to the
Country field, I enter "Japan," since that's where he lives. Access should,
in the best of all possible worlds, then look in Table 2 for the entry
for Japan, which holds (in named fields, of course) the French name
and the telephone code. Access places these bits of data into the
appropriate fields in the original table so I don't have to do it, and
Bob's your uncle.
I've experimented with the DLookUp function to a point; I've even managed
to get a non-interactive version of this working for the French name (ie,
I've an action query that runs through the database and supplies the
French name for every record). What I want still eludes me.
Ideas?
The *real* kicker is that ultimately my boss would like this to work
very smoothly -- ie, as soon as you type enough of the english name for
a country to uniquely identify it in the database, it finishes the name
AND fills the other two fields. I don't know how practical that is,
but it's a goal. I've got to get this working the regular way first, though.
Thanks in advance.
+----------------------------------------------------------------+
| Chet Farmer, Assistant Director | tel 205-348-9494 |
| Project IDEALS | cfarmer1@ua1vm.ua.edu |
| The University of Alabama | chet.farmer@genie.geis.com |
|----------------------------------------------------------------|
| C is for Cookie, and that's good enough for me. -- C. M. |
+----------------------------------------------------------------+
=========================================================================
Date: Wed, 25 Aug 1993 08:12:13 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Clyde F. Bingham III" <BINGHAMC@WSUVM1.BITNET>
Subject: Re: Output of job "Easter Egg Hunt"
In-Reply-To: Message of Wed,
25 Aug 1993 11:02:58 EST from <sdahne@MAIL.LMI.ORG>
I copied this command from a letter to the ACCESS list which said you
could get information on hidden ACCESS screens using it. Well, I guess it
didn't work.
I gave up on it and don't intend to send it again.
Thanks.
=========================================================================
Date: Wed, 25 Aug 1993 10:33:49 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Steve Bratten <GE0793@SIUCVMB.BITNET>
Subject: What version of VB do I need...
Does the standard version of Visual Basic provide access to the Access
file structure?
What are the main differences between the standard and professional
versions?
Sorry if these are old questions but I need to know. :-)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
| o__ |
| Steve Bratten _.>/^_ BITNET < GE0793@SIUCVMB > |
| Graduate School (_) \(_) INTERNET < GE0793@SIUCVMB.SIU.EDU > |
| Southern Illinois University |
| Carbondale IL 62901-4716 \o \o \o Graduate School |
| Voice: (618) 453-4552 |> |> |> Southern Illinois University |
| Fax: (618) 453-4562 < \ < \ < \ Carbondale, IL 62901-4716 |
| |
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^Steve Bratten^^^^^^^^^
=========================================================================
Date: Wed, 25 Aug 1993 11:52:38 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: What version of VB do I need...
In-Reply-To: Message of Wed, 25 Aug 1993 10:33:49 -0500 from <GE0793@SIUCVMB>
On Wed, 25 Aug 1993 10:33:49 -0500 Steve Bratten said:
>Does the standard version of Visual Basic provide access to the Access
>file structure?
>
>What are the main differences between the standard and professional
>versions?
>
>Sorry if these are old questions but I need to know. :-)
>
The Data control is available in both versions.
Methods available ONLY in the PROFESSIONAL edition are:
Table Methods: AddNew, Clone, Close, CreateDynaset, CreateSnapshot, Delete,
Edit, FindFirst, FindLast, FindNext, FindPrevious, ListFields,
ListIndexes, MoveFirst, MoveLast, MoveNext, MovePrevious,
Seek, Update...in other words, ALL of the Table methods in
VB 3.0 are only available in the Pro edition.
Dynaset Methods: Clone, ListFields, ListIndexes only in Pro edition.
Snapshot Methods: Clone, Close, FindFirst, FindLast, FindNext, FindPrevious,
ListFields, ListIndexes, MoveFirst, MoveLast, MoveNext,
MovePrevious...as with Table methods, ALL of the Snapshot
methods are ONLY available in the Pro edition.
Most of the Dynaset methods <are> available in the Standard Edition, viz.:
AddNew, Close, Delete, Edit, FindFirst, FindLast, FindNext,
FindPrevious, MoveFirst, MoveLast, MoveMext, MovePrevious,
Update.
As you can no doubt see, the Professional edition for $100 more (if you
have the upgrade offer for registered users of Access) may be well worth
the price if you want the added functionality.
The above is from page 16 of the VB 3.0 language reference.
I'm going to harp on the ONE method that I WISH MS would have included
in the Access Engine for VB: FINDRECORD!!!!!!!!!!
Also check the archives for this list...at some point a month or so ago
I posted the professional edition-specific added attractions from the
VB brochure.
HTH,
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Wed, 25 Aug 1993 13:03:56 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Output of job "Easter Egg Hunt"
% I received the following message:
%
% ---------------------------------------------------------------------------
% Subject: Output of your job "Looking"
% Author: BITNET list server at UIUCVMD (1.7f) <LISTSERV@VMD.CSO.UIUC.EDU>
% Any ideas on what happened?
% Scott Dahne
Not offhand. I just tried a few minutes ago and received a 76K file, which is
about what I've expected. I
haven't checked to see if anything new has appeared, but like most other cyclic
topics, Easter Eggs make
their rounds on the WIN3-L regularly by those discovering them for the first
time.
I know the file works as that's my standard LISTSERV template (all you have to
do is change
the keywords and the list you're looking in).
BTW, you usually get two sets of files when performing LISTSERV commands via a
file like that: one
with the "console log", the other with the results.
Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
CARmel, Indiana
=========================================================================
Date: Wed, 25 Aug 1993 12:16:52 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: Output of job "Easter Egg Hunt"
In-Reply-To: Message of Wed,
25 Aug 1993 13:03:56 EDT from <72410.2162@COMPUSER VE.COM>
Yes, as Phil pointed out, you're going to get two responses from the
listserver--one, like you reposted to the list, that only summarizes
the job and tells you what happened, and the other, the actual data
returned to you. On a VM machine, this will likely come as a Netdata
file and won't show up as mail (although it <will> show up in your
reader). You type RECEIVE at the command prompt to get it out of the
reader and onto your disk.
In VAX/VMS, there is another set of commands used to receive a file
that are distinct from MAIL or PMDF. Not being a VAX user except when
forced :), I don't know what they are. Chances are, the file got sent
to you and you just aren't aware of it. Also note that file transfers
are slower than mail most of the time...the file may still be in
transit.
AND if you're on AOL, you're out of luck on file transfers in the
first place. Sorry. That's an AOL thing, not Internet.
HTH,
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Wed, 25 Aug 1993 13:18:24 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Harry Yeatts <HYEATTS@VTVM1.BITNET>
Subject: combos and concatenations
Hello Accessers:
I've got a bit of a puzzle I'm hoping someone out there can shed some
light on.
In the detail section of a report, I have two controls:
[author]
=[title]&" "&"("&[year]&")"
which gives: Deighton, Len Violent Ward (93)
This works PERFECTLY on its own. However, when I use a macro to open
the report and filter the [author] records...all hell breaks loose:
I get an MSACCESS error message with two choices: close or ignore.
Then I get an APPLICATION ERROR message citing a General Protection
Fault with msaccess.exe.
The macro that opens the report has:
OpenReport
SelectObject
ApplyFilter
The "where" argument under ApplyFilter:
[author]=Forms![which author? form]![author pick list]
The [author pick list] is a combo box on a form used specifically
to allow the user to pick a particular author. This works fine
too *IF* I don't have the above concatenation on the form, and
just have [title] and [year] separate.
So I'm between a rock and a hard place on this one. Any ideas?
I'll be glad to furnish more particulars...
Harry
Harry Yeatts (HYEATTS) INTERNET: VTVM1.CC.VT.EDU
Virginia Tech BITNET: VTVM1
Blacksburg, Virginia PHONE: 703-231-5141
Notes:
(1) I left [author] out of the expression on the report because I
wanted to hide duplicates.
(2) I didn't use |bars| in the concatenation in the report expression
because they don't work. (Even on-line help doesn't use them.)
(3) I'm using Access 1.1
=========================================================================
Date: Wed, 25 Aug 1993 13:40:53 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Amy C. Park" <SBALAB2@UCONNVM.BITNET>
Subject: Easter Egg Search...
I'm having trouble with the Easter Egg Hunt, too! :-)
Received: from VMD.CSO.UIUC.EDU by UCONNVM.UCONN.EDU (Mailer R2.08 R208004)
This is the message I have been getting - is there a problem with that database
or something? HELP! Any more brilliant ideas?
VMD.CSO.UIUC.EDU (LMail V1.1d/1.7f) with BSMTP id 8850; Wed,
25 Aug 1993 12:40:00 -0500
%Date: Wed, 25 Aug 1993 12:40:00 -0500
%From: BITNET list server at UIUCVMD (1.7f) <LISTSERV@VMD.CSO.UIUC.EDU>
%Subject: File: "DATABASE OUTPUT"
%To: SBALAB2%UCONNVM.bitnet@VMD.CSO.UIUC.EDU
%> Search EASTER EGG in WIN3-L
%--> Error: Database WIN3-L does not exist. Database removed from search list.
%--> No hit.
%
%> index
%--> No hit in previous search, nothing to list.
%
%> PRINT ALL
%--> No hit in previous search, nothing to print.
=========================================================================
Date: Wed, 25 Aug 1993 16:24:03 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Greg Fairnak <GFAIRNA@AMERICAN.EDU>
Organization: The American University
Subject: VIRUS ALERT
For those of you who use VB 3.0 pro and Visual control pack for C++
the file termset.frm is infected with the shake virus. I find that most
anti virus programs cannot locate it. I thought you folks on the list should
know.
Regards,
Greg
=========================================================================
Date: Wed, 25 Aug 1993 14:03:47 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Dmitry Serebrennikov <dmitry@UCSEE.BERKELEY.EDU>
Subject: Re: Out of Memory when changing Datatype
Sorry, in my present setup I can't quote, so...
In the original post the problem is that there is out of memory message during
chaniging a fild datatype in the table design view.
I had that happen too. The possible solution is to create a second field with a
different name of the desired datatype and run an update query that will copy
the values from one field to another (doing nessosory conversions on the go).
Then you'll be able to just delete the first field and rename the second to the
needed name.
Now you may still run into the problems with memory (not enough memory to undo,
etc.)
but at least you'll be able to finish. If you are still out of memory -- try
doing the query piece by piece (i.e. use a criteria like [ID] < 2000, assuming
ID is
like record number).
I know it's a pain, but I don't know a better solution...
dmitry@ucsee.berkeley.edu
=========================================================================
Date: Wed, 25 Aug 1993 14:21:19 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Tim King <uswnvg!tcking@UUNET.UU.NET>
Subject: Re: VIRUS ALERT
In-Reply-To: <9308252031.AA12163@relay1.UU.NET> from "Greg Fairnak" at Aug 25,
93 04:24:03 pm
Thus spake Greg Fairnak:
> For those of you who use VB 3.0 pro and Visual control pack for C++
> the file termset.frm is infected with the shake virus. I find that most
> anti virus programs cannot locate it. I thought you folks on the list should
> know.
How do you know this? What do we DO about it?
--
Tim King, tcking@uswnvg.com
US West NewVector Group Inc., Bellevue, Washington
=========================================================================
Date: Wed, 25 Aug 1993 18:22:49 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: ?
Because there has been so much dedicated to the crossover for VB3 & Access,
I'm
curious: is there any interest in a book which would be written at the
developer level
for persons wanting to develop databases using VB3, but crossing over to
Excel,
Access, etc., perhaps even dabbling in the forthcoming Visual Basic for
Applications
(aka Object Basic)
???
Let me hear your voice!
Phil Paxton
Development Editor
SAMS/Prentice Hall Computer Publishing
Carmel, Indiana
=========================================================================
Date: Wed, 25 Aug 1993 17:32:59 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: VIRUS ALERT
In-Reply-To: Message of Wed,
25 Aug 1993 16:24:03 EDT from <GFAIRNA@AMERICAN.ED U>
Greg, can you give us some specifics, like which virus programs <don't>
detect it, where you heard about it, etc?
Thanks,
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Wed, 25 Aug 1993 17:35:01 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: ?
In-Reply-To: Message of Wed,
25 Aug 1993 18:22:49 EDT from <72410.2162@COMPUSER VE.COM>
Phil, count my vote as "yes" on the proposed cross-platform book. Sounds
like a good idea to me!
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Thu, 26 Aug 1993 12:22:00 GMT+1200
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Daniel Bar-Even <CSDXB@BAXTER.NATLIB.GOVT.NZ>
Organization: National Library of New Zealand
Subject: Checking for relational integrity
Help!
I've got two tables imported from a paradox database with integrity
problems. They are joined on a key field (Clientno). There should
not be a record without a corresponding record in the other table.
What is the easiest way to find those records?
On other systems I would've written an SQL statement like:
Select * from table1
where clientid not in (Select clientid from table2)
Can't seem to do anything like this in Access
TIA
**********************************************************
Daniel Bar-Even (daniel.bar-even@baxter.natlib.govt.nz)
Client Support Analyst
National Library of New Zealand
Te Puna Matauranga o Aotearoa
P.O. Box 1467
Wellington
New Zealand Ph: (04) 474-3000 Fax: (04) 474-3161
**********************************************************
=========================================================================
Date: Wed, 25 Aug 1993 20:38:53 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: George Raudabaugh <RAUDABAUGH@IDICL1.IDI.OCLC.ORG>
Subject: Re: Checking for relational integrity
Use an outer join:
Join table1.clientid to table2.clientid. Double click
on the join line. Select option 2. Add a restriction of Is Null to
table2.clientid.
I haven't tried this, but it should work. If it isn't exactly correct,
see the doc on outer joins.
George
--
George Raudabaugh Manager/Document Technologies
Information Dimensions, Inc. raudabaugh@idi.oclc.org (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio 43017 (614) 761-7309 (voice mail)
=========================================================================
Date: Wed, 25 Aug 1993 20:14:25 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Tim King <uswnvg!tcking@UUNET.UU.NET>
Subject: Re: ?
In-Reply-To: <9308252231.AA10476@relay1.UU.NET> from "Phil Paxton" at Aug 25,
93 06:22:49 pm
Thus spake Phil Paxton:
>
> Because there has been so much dedicated to the crossover for VB3 & Access,
> I'm
> curious: is there any interest in a book which would be written at the
> developer level
> for persons wanting to develop databases using VB3, but crossing over to
> Excel,
> Access, etc., perhaps even dabbling in the forthcoming Visual Basic for
> Applications
> (aka Object Basic)
What *I* really need is an advanced book that focuses on database
development in VB 3.0 using the Access engine. The VB 3.0 books I've
seen on the market so far devote just a few pages to the basics of the
data control. One book (I won't say whose name is on the cover, but his
initials are Peter Norton) makes no mention at all of the database
capabilities; doesn't even show the data control in pictures of the
toolbox.
--
Tim King, tcking@uswnvg.com
US West NewVector Group Inc., Bellevue, Washington
=========================================================================
Date: Thu, 26 Aug 1993 07:52:00 +01
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Nilsson Jimmy, HK/R IDE" <Jimmy.Nilsson@IDE.HK-R.SE>
Subject: Faster startup with ADK?
Is there anyone who know if the startup of an Access ADK-application goes
any faster than it does to start the usual Access? If so, how big is the
difference?
The reason for my question is that it really takes some time to start Access
on a network!
Jimmy Nilsson
University of Karlskrona/Ronneby, Sweden
Jimmy.Nilsson@ide.hk-r.se
=========================================================================
Date: Thu, 26 Aug 1993 05:46:54 PDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Morris Myers <xrysta@MCODE.AMDAHL.COM>
Subject: Re: ?
Phil, I would consider buying a book that provided cross-over development
guidance and examples.
--
-----------------------------------------------------------------------
Morris Myers [Standard Disclaimer]
Amdahl Corporation
M/S 205 Phone: 408-746-4798
Bldg. M3 Room 311 Fax: 408-629-4374
1230 E. Arques Avenue Email: xrysta@mcode.amdahl.com
Sunnyvale, CA 94088-3470 or: morris@xrysta.birdsong.suvl.ca.us
=========================================================================
Date: Thu, 26 Aug 1993 08:51:20 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: CHARLES FRANKLIN <CF03@ADMIN.SWT.EDU>
Organization: Southwest Texas State University
Subject: Re: VisualBASIC Development Book
>Because there has been so much dedicated to the crossover for VB3 & Access,
>I'm curious: is there any interest in a book which would be written at the
>developer level for persons wanting to develop databases using VB3, but
>crossing over to Excel, Access, etc., perhaps even dabbling in the forthcoming
>Visual Basic for Applications (aka Object Basic)
We're just now getting into some client/server development perhaps using
VisualBasic and/or Visual C++.
We'd be very interested in a development book that talks about these products
interfacing with standard Windows software (Word, Excel, Access, etc) also OLE
and DDE. It would also be of benefit if it would also have a chapter on SQL
access to mainframe databases (Rdb in particular, but others would be a benefit
as well)- perhaps working with EDA/SQL or someother middleware as examples.
Sounds more like a three volume reference set :-)
Charles Franklin
Southwest Texas State University
Information System and Services
cf03@admin.swt.edu
(512) 245-2271
=========================================================================
Date: Thu, 26 Aug 1993 09:58:04 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Greg Fairnak <GFAIRNA@AMERICAN.EDU>
Organization: The American University
Subject: virus stuff
Guys,
Do you ever feel like you are chasing a ghost? I have two brand new
systems which I have installed MS Dos, VB, Win and other MS programs.
The computer began to exhibit virus like behavior aka SHAKE. Now, CPAV
and MSAV did not detect it. I also use an AES adaptive expert system anti
virus program which tells me that it thinks that this file termset.frm has a
virus. Now this could be a false negative, because the file is in text ASCII
format. Now on the one hand I have a brand new damaged computer from a virus
type problem. On the other hand, my virus is contained in an acsii(? :-{ )
file. Now I called MS to tell them about what I found. This type of stuff
usually involves shooting the messenger. You told us, so it is your fault.
My only intention is to alert developers about the potential of the problem.
Now, I would keep that file on a separate floppy for a while. I will continue
to test these files and see if I can find the problem.
Now maybe I win the award for hole in the foot, shooting my gun while it is
still in the holster. :-)
Although I will continue testing until I find the problem. I hope that I am
wrong, but I still have the infected brand new machine.
Thanks for your time,
Greg
=========================================================================
Date: Thu, 26 Aug 1993 10:25:42 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Greg Fairnak <GFAIRNA@AMERICAN.EDU>
Organization: The American University
Subject: no virus
Okay,
I .frm file has the word Shake in it many times. This set off the
AES. The culprit was a 1226 virus which hopped on top of MSAV and then
infected the floppy drives. My apologies to the people at MS for mentioning
this potential problem. Although this does tell me that MSAV does not have
any anti piggybacking protection.
Back to our regularly scheduled program.
G
=========================================================================
Date: Thu, 26 Aug 1993 08:13:49 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Re: no virus
In-Reply-To: <9308261437.AA24557@hermes.intel.com>; from "Greg Fairnak" at Aug
26, 93 10:25 am
> Okay,
> I .frm file has the word Shake in it many times. This set off the
> AES. The culprit was a 1226 virus which hopped on top of MSAV and then
> infected the floppy drives. My apologies to the people at MS for mentioning
> this potential problem. Although this does tell me that MSAV does not have
> any anti piggybacking protection.
>
> Back to our regularly scheduled program.
Pardon, but I am sure I am not alone here in knowing _nothing_ about viruses
beyond the ability to scan for them at regular intervals. First, what is this
Shake virus? Next, what is a 1226 virus? Finally, please be a bit more
explanative when discussing this stuff. We don't all read comp.virus ya
know. Oh yes. Don't know what "the AES" is either.
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Thu, 26 Aug 1993 14:34:00 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: DAVID FARR <dfarr@ASRR.ARSUSDA.GOV>
Subject: Checking for relational integrity
The Microsoft FastTips Fax service, 206-635-7051, has a document
#95326 that may help. 'For example, say you have two tables, joined on
a common field (customer ID). Your goal is to find the records in
Table1 that do not have a matching customer ID in table2.'
Dave Farr
=========================================================================
Date: Thu, 26 Aug 1993 06:18:24 -0400
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "John M. King" <p00756@PSILINK.COM>
Organization: KING Systems
Subject: Re: ?
In-Reply-To: <9308252231.AA00954@rampage.psi.net>
>DATE: Wed, 25 Aug 1993 18:22:49 EDT
>FROM: Phil Paxton <72410.2162@COMPUSERVE.COM>
>
>curious: is there any interest in a book which would be written at the
>developer level
>for persons wanting to develop databases using VB3, but crossing over to
>Excel,
>Access, etc., perhaps even dabbling in the forthcoming Visual Basic for
>Applications
>(aka Object Basic)
>
I would be interested in such a book. Currently, I am involved in
developing an application in Access, with hooks into Word. I have
thought of using VB 3.0 to develop some conversion routines for new
releases, etc.
It all seems to be tying together. "Seamlessly" is a cliche, but that
is what users want.
********************************************************************************
* John King KING Systems *
* CompuServe 72060,3706 Internet p00756@psilink.com *
* MCI Mail 553-0074 Fax 804-270-6524 *
********************************************************************************
=========================================================================
Date: Thu, 26 Aug 1993 17:08:00 LCL
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: mkro <mkro.DIS-PC@BMAILIN.ITG.TI.COM>
Subject: Printing Directly to a printer
Hello!!
Have anyone out there done any printing using Access basic?
I have an Access application that needs to print AIRBORN shipping labels
on an AIRBORN supplied form that is 4" high and 7 1/4" wide.
The information on the airbill will come from various tables within the
database. These forms are 3 layers carbonated, so an impact printer is
required.
Has anyone coded print statements directly to a printer port?
Is anyone trying to do something similar?
Anyone have any design suggestions?
Also, is anyone implementing any BARCODE input/output solutions in their
Access App?
Regards,
Mike Kroeger
*** uuencoded BINARY enclosure ***
The section below this line contains an MHS attachment. To extract it,
copy this message to a file and use the program UUDECODE. For information
on using UUDECODE on UNIX systems, type the command 'man uudecode'. The
attachment name was originally: ATTRIBS.BND
---------------
begin 644 attribs.bnd
M0F5Y;VYD(%!A8VME9"!!='1R:6)U=&5S``;_&VIK*```````4')I;G1I;F<@
M1&ER96-T;'D@=&\@82!P<FEN=&5R(```````````````````````````````
M````````````````````````````````````````````````````````````
M`&UK<F\`````````````````````````````````````````````````````
M```````````````````````````````````T,$5#-T,R0S`Q0SE!,44P````
M````````0F5Y;VYD(%!R;W!R:65T87)Y($1A=&$:``````0`````````!``%
M````````````````````````````1F]R;01-96UO`0`````````5``,`````
M``````````````````````!5<V4@4')O<&]R=&EO;F%L($9O;G0!``$1````
M``````0`<P,``````````````````````````%1E>'1P`DAE;&QO(2$@(`H@
M(`H@("!(879E(&%N>6]N92!O=70@=&AE<F4@9&]N92!A;GD@<')I;G1I;F<@
M=7-I;F<@06-C97-S(&)A<VEC/R`*22!H879E(&%N($%C8V5S<R!A<'!L:6-A
M=&EO;B!T:&%T(&YE961S('1O('!R:6YT($%)4D)/4DX@<VAI<'!I;F<@;&%B
M96QS"F]N(&%N($%)4D)/4DX@<W5P<&QI960@9F]R;2!T:&%T(&ES(#0B(&AI
M9V@@86YD(#<@,2\T(B!W:61E+@H*5&AE(&EN9F]R;6%T:6]N(&]N('1H92!A
M:7)B:6QL('=I;&P@8V]M92!F<F]M('9A<FEO=7,@=&%B;&5S('=I=&AI;B!T
M:&4@"F1A=&%B87-E+B`@5&AE<V4@9F]R;7,@87)E(#,@;&%Y97)S(&-A<F)O
M;F%T960L('-O(&%N(&EM<&%C="!P<FEN=&5R(&ES(`IR97%U:7)E9"X*("`@
M2&%S(&%N>6]N92!C;V1E9"!P<FEN="!S=&%T96UE;G1S(&1I<F5C=&QY('1O
M(&$@<')I;G1E<B!P;W)T/PH@("!)<R!A;GEO;F4@=')Y:6YG('1O(&1O('-O
M;65T:&EN9R!S:6UI;&%R/PI!;GEO;F4@:&%V92!A;GD@9&5S:6=N('-U9V=E
M<W1I;VYS/PH*06QS;RP@:7,@86YY;VYE(&EM<&QE;65N=&EN9R!A;GD@0D%2
M0T]$12!I;G!U="]O=71P=70@<V]L=71I;VYS(&EN('1H96ER(`I!8V-E<W,@
M07!P/PH*4F5G87)D<RP*36EK92!+<F]E9V5R"OT``P!P`O8``0`!````$P`!
M``$``0!P`@```````#C_````````D`$``````````$-O=7)I97(@3F5W````
M``````````````````````````````$``0`*``$`"P`-``$`#@!-``$`3@"6
M``$`EP#3``$`U`#4``$`U0`=`0$`'@%F`0$`9P%P`0$`<0&Q`0$`L@'>`0$`
MWP$"`@$``P(#`@$`!`)-`@$`3@)9`@$`6@):`@$`6P)C`@$`9`)P`@$`<0)Q
M`@```````````````&0``7@``?```6@!`>`!`5@"`=`"`4@#`<`#`3@$`;`$
M`2@%`:`%`1@&`9`&```````````````0``8`````````````````````````
8``!!='1A8VAM96YT($-O=6YT!```````
`
end
=========================================================================
Date: Fri, 27 Aug 1993 10:14:00 LCL
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: RH <RH.DIS-PC@BMAILIN.ITG.TI.COM>
Subject: Suppressing the Access sign-on screen
Hello!
Does anyone know how to suppress the sign-on screen that says:
Microsoft Access Version 1.1
Copyright...
Thanks in advance,
Bob Hanschke
Texas Instruments, Inc.
Dallas, TX
Regards,
Bob Hanschke MSGID RH Office (214) 917-6393 Fax (214) 917-1505
=========================================================================
Date: Thu, 26 Aug 1993 21:57:58 CDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Richard Moldwin <rmoldwin@MIDWAY.UCHICAGO.EDU>
Subject: Re: VIRUS ALERT
In-Reply-To: Your message of Wed, 25 Aug 1993 16:24:03 EDT
Well, How do we get rid of the shake virus if we can't detect it. Please
tell us more!
=========================================================================
Date: Fri, 27 Aug 1993 14:04:53 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Global variable problem
I have a global variable, declared as such in a module's declarations section.
My problem is, some AccessBasic functions seem to recognize it fine, and
others do not. In other words, sometimes when I need to know the value in
this variable, it is there, and in other functions, it is empty. Is there
something I should know about global variables in Access?
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Fri, 27 Aug 1993 09:11:00 +0100
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Comments: Sent using PMDF-822 , routing is done by ECNICE
From: Bart Schaap <schaap@ECN.NL>
Subject: security of Access database
Hello out there,
I am using version 1.0 of Access and I think I've found a serious
security problem.
In a networked environment, use of an Access database is controlled
by means of a system.mda file which must be located on a disk where
all potential users have read/write permission.
Security info for a database is stored there and if a user uses this
file, security is not a problem.
However ALL SECURITY IS LOST if someone uses such a database while
using his own (local) system.mda file. Our network software is
DEC PCSA version 4.1.
Is this still the same in version 1.1?
Is there a solution for this problem?
Thanks, Bart.
=========================================================================
Date: Fri, 27 Aug 1993 20:19:00 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: George Raudabaugh <RAUDABAUGH@IDICL1.IDI.OCLC.ORG>
Subject: Re: Checking for relational integrity
I got confirmation that my posted recommendation about this problem
worked. So instead of using the FAX service below, just be open about
responding to other questions that come across on the list. If your
company requires spending money on free information, please send email
about how I want the check made out ;).
George
--
George Raudabaugh Manager/Document Technologies
Information Dimensions, Inc. raudabaugh@idi.oclc.org (work email)
5080 Tuttle Crossing Blvd.
Dublin, Ohio 43017 (614) 761-7309 (voice mail)
>From: IN%"ACCESS-L%INDYCMS.BITNET@uga.cc.uga.edu" "Microsoft Access Database D
iscussion List" 27-AUG-1993 17:38:39.91
>To: IN%"ACCESS-L%INDYCMS.BITNET@uga.cc.uga.edu" "Multiple recipients of list A
CCESS-L"
>CC:
>Subj: Checking for relational integrity
>
>The Microsoft FastTips Fax service, 206-635-7051, has a document
>#95326 that may help. 'For example, say you have two tables, joined on
>a common field (customer ID). Your goal is to find the records in
>Table1 that do not have a matching customer ID in table2.'
>
>Dave Farr
=========================================================================
Date: Mon, 30 Aug 1993 16:15:01 GMT+1200
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Daniel Bar-Even <CSDXB@BAXTER.NATLIB.GOVT.NZ>
Organization: National Library of New Zealand
Subject: Sorting Criteria
Does anybody know how I can get a query or a report to sort by a
field specified in a form?
I have a form called ReportCriteria which I use to select records for
a report. I can select a field from a field list in the form but I
don't know how to use that sort on.
I though that I'd to be able to say something like "ORDER BY
Forms!ReportCriteria!SortByField" in my query. Unfortunately that
doesn't have any effect.
=========================================================================
Date: Mon, 30 Aug 1993 08:48:24 -0500
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Jack Marshall <Jack.Marshall@CDC.COM>
Subject: Accessing Table's Field
I would like to be able to invoke a function from the ValidateRule
that would set another field [LastModDate] in the same table. At first
glance I thought [LastModDate] = NOW would work, but the function
apparently doesn't know what table to use. I then tried things like
[mytablename]![LastModDate] = NOW, also without success. As I got more
intense I thought of things like setting a pointer to the CurrentDB,
but even this way I couldn't find a way to point to the "CurrentTbl".
I was able to make the function work against a form by using
FORM![mytablename]![LastModDate] = NOW - surely there is a way to do
the same thing from the table's spreadsheet view.
I would sure like to understand this issue - please send any advice
directly to me since I'm no longer a memeber of the list (maybe I should
be!)
+------------------------------+---------------------------+
| Jack Marshall | (612) 482-4408 (voice) |
| Control Data Systems, Inc. | (612) 482-4417 (fax) |
| 4201 Lexington Ave. N. | |
| Arden Hills, MN 55126-6198 | Jack.Marshall@cdc.com |
+------------------------------+---------------------------+
=========================================================================
Date: Mon, 30 Aug 1993 12:59:41 EDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Phil Paxton <72410.2162@COMPUSERVE.COM>
Subject: Re: Suppressing the Access sign-on screen
% Does anyone know how to suppress the sign-on screen that says:
%
% Microsoft Access Version 1.1
%
% Copyright...
Just out of curiosity, what makes this a sign-on screen?
BTW, it's normally called a "splash screen"
=========================================================================
Date: Mon, 30 Aug 1993 11:33:09 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: johnvon@HALCYON.COM
Subject: Re: Sorting Criteria
In-Reply-To: <199308301812.AA08372@halcyon.com> from "Daniel Bar-Even" at Aug
30, 93 04:15:01 pm
>
> Does anybody know how I can get a query or a report to sort by a
> field specified in a form?
>
> I have a form called ReportCriteria which I use to select records for
> a report. I can select a field from a field list in the form but I
> don't know how to use that sort on.
>
> I though that I'd to be able to say something like "ORDER BY
> Forms!ReportCriteria!SortByField" in my query. Unfortunately that
> doesn't have any effect.
>
You have to concatenate the variable into the query string. Build the
query using the query builder, putting in a sort for one of the fields.
Run the query to make sure it works. Go into view SQL, highlight all of
the SQL, and use CTRL-C to copy it to the clipboard. In Access BASIC,
you will need to rebuild the query. You then need to assign a variable
to you SQL and make a querydef out of it. Your code will look something
like:
SQLString = "Select * from foo order by '" &
Forms!ReportCriteria!SortByField & "' with owneraccess option"
You next need to use the OpenQueryDef method to open your query, the set
it's SQL property to the above string (customized for you!), close the
query, and run the report based on the query. When you test, make sure
your SortByField has a value, or put a trap for zero length strings in
your code.
Good luck.
John
"
=========================================================================
Date: Mon, 30 Aug 1993 14:50:40 CDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: David Crookall <CROOKALL@UA1VM.BITNET>
Organization: Simulation & Gaming - Project IDEALS
Subject: Re: Sorting Criteria
In-Reply-To: Message of Mon,
30 Aug 1993 16:15:01 GMT+1200 from <CSDXB@BAXTER.NATLIB.GOVT.NZ>
I'd also like to know the answer to
Daniel Bar-Evans's question aboiut
sorting. Thanks, David Crookall
=========================================================================
Date: Mon, 30 Aug 1993 14:57:58 CDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: David Crookall <CROOKALL@UA1VM.BITNET>
Organization: Simulation & Gaming - Project IDEALS
Subject: Re: Sorting Criteria
In-Reply-To: Message of Mon,
30 Aug 1993 11:33:09 -0700 from <johnvon@HALCYON.COM>
Oups, sorry,
that was a quick reply about sorting
thanks, david
=========================================================================
Date: Mon, 30 Aug 1993 15:00:37 CDT
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Comments: Resent-From: CROOKALL@UA1VM
Comments: Originally-From: Chet Farmer <CFARMER1@UA1VM>
From: David Crookall <CROOKALL@UA1VM.BITNET>
Organization: Project IDEALS -- The University of Alabama
Subject: Automatic field updates
In-Reply-To: Message of Wed, 25 Aug 1993 16:23:24 +0800 from <NCLCHAN@NTUVAX>
Hwoever, I do have another question. I'd be most grateful for
a reply.
I have a largish database of names and addresses (just under 2k records).
For convenience's sake, I include a field for both Country AND Country-in-
French. I also include a field for the country telephone code (eg, 44 for
England).
My question is this. Is there an easy way to have the French-country and
country-code fields filled automatically in the primary table/data entry
form given an entry in the regular-country field AND another table with
each country's corresponding French name and telephone code?
For example: I enter John Doe into the database. When I get to the
Country field, I enter "Japan," since that's where he lives. Access should,
in the best of all possible worlds, then look in Table 2 for the entry
for Japan, which holds (in named fields, of course) the French name
and the telephone code. Access places these bits of data into the
appropriate fields in the original table so I don't have to do it, and
Bob's your uncle.
I've experimented with the DLookUp function to a point; I've even managed
to get a non-interactive version of this working for the French name (ie,
I've an action query that runs through the database and supplies the
French name for every record). What I want still eludes me.
Ideas?
The *real* kicker is that ultimately my boss would like this to work
very smoothly -- ie, as soon as you type enough of the english name for
a country to uniquely identify it in the database, it finishes the name
AND fills the other two fields. I don't know how practical that is,
but it's a goal. I've got to get this working the regular way first, though.
Thanks in advance.
+----------------------------------------------------------------+
| Chet Farmer, Assistant Director | tel 205-348-9494 |
| Project IDEALS | cfarmer1@ua1vm.ua.edu |
| The University of Alabama | chet.farmer@genie.geis.com |
|----------------------------------------------------------------|
| C is for Cookie, and that's good enough for me. -- C. M. |
+----------------------------------------------------------------+
=========================================================================
Date: Mon, 30 Aug 1993 13:35:29 PDT
Reply-To: thamilto@pcocd2.intel.com
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Tony Hamilton - FES ERG~" <thamilto@PCOCD2.INTEL.COM>
Subject: Report groupings
Decided that this might be eaiser to ask of the list than Microsoft,
because of the visual nature:
When grouping data in reports, Access tends to groups things like:
XXXXX
YYYYYY
ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
YYYYYY
ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
Instead, I would like to group as follows:
XXXXX YYYYYY ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
YYYYYY ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
ZZZZZ ZZZZZZZZ ZZZZZ
The difference is that I want the group headings to be in-line with
the rest of the data. Is it possible to do this in Access, or am I just
missing something obvious?
--
Tony Hamilton |
-Intel Corporation | voice: 916-356-3070
--Folsom Engineering Services | mailstop: FM2-55
---Engineering Resource Group | email: thamilto@pcocd2.intel.com
----Software Technician |
=========================================================================
Date: Mon, 30 Aug 1993 17:51:40 PST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Jon D Gardner <Jon_D_Gardner@CCM.HF.INTEL.COM>
Subject: Re: Suppressing the Access sign-on screen
Starting Access with a "/s" parameter will bypass the splash screen.
Set the Command line to:
C:\ACCESS\MSACCESS.EXE /s
int Program Manager's Program Item Properties dialog box.
Jon Gardner
Intel SQL Server Program
Folsom, CA
(916) 356-2664
--------------------------------------------------------------
>Hello!
>
>Does anyone know how to suppress the sign-on screen that says:
>
> Microsoft Access Version 1.1
>
> Copyright...
>
>
>
>Thanks in advance,
>Bob Hanschke
>Texas Instruments, Inc.
>Dallas, TX
>
>Regards,
>Bob Hanschke MSGID RH Office (214) 917-6393 Fax (214) 917-1505
=========================================================================
Date: Tue, 31 Aug 1993 09:19:04 +0800
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: NCLCHAN@NTUVAX.BITNET
Subject: Maximize the form before opening form
Does anyone know how to maximize the form before the form is opened ?
Normally Macro - openform & then maximize.
It is so UGLY to see the "small" form being enlarge when you execute the macro.
Is there a way to see the maximized form on the screen once you execute the macr
o ?
Chor Ling
NCLCHAN@NTUVAX.NTU.AC.SG
=========================================================================
Date: Tue, 31 Aug 1993 09:29:20 +0200
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Stefan Focke <focke@GMD.DE>
Subject: Re: Accessing Table's Field
>I would like to be able to invoke a function from the ValidateRule
>that would set another field [LastModDate] in the same table. At first
>glance I thought [LastModDate] = NOW would work, but the function
>apparently doesn't know what table to use. I then tried things like
>[mytablename]![LastModDate] = NOW, also without success. As I got more
>intense I thought of things like setting a pointer to the CurrentDB,
>but even this way I couldn't find a way to point to the "CurrentTbl".
>I was able to make the function work against a form by using
>FORM![mytablename]![LastModDate] = NOW - surely there is a way to do
>the same thing from the table's spreadsheet view.
I think, that it is not possible because you are only allowed to write a
expression as a validation rule. If you want to update another field you
need a macro or Access Basic program assigned to a field in a form.
Stefan
----------------------------------------------------------------------
Stefan Focke Tel. 02241-14-3154
GMD-ISA e-mail: focke@gmd.de
Rathausalle 10
D-W 5205 Sankt Augustin 1
********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date: Tue, 31 Aug 1993 09:32:12 +0200
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Stefan Focke <focke@GMD.DE>
Subject: Re: Automatic field updates
>I've experimented with the DLookUp function to a point; I've even managed
>to get a non-interactive version of this working for the French name (ie,
>I've an action query that runs through the database and supplies the
>French name for every record). What I want still eludes me.
DLookUp should work for you. I did something simular and it worked. Prehaps
you should post the code you use.
Stefan
----------------------------------------------------------------------
Stefan Focke Tel. 02241-14-3154
GMD-ISA e-mail: focke@gmd.de
Rathausalle 10
D-W 5205 Sankt Augustin 1
********** MS-Word: From the guys who brought us EDLIN ********
=========================================================================
Date: Tue, 31 Aug 1993 09:06:49 BST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: "Anne L Zorner R27.G5/" <ALZ@IBM-B.RUTHERFORD.AC.UK>
Subject: re security
SQL Support Section (SQS) Mail ALZ@UK.AC.RL.IB
===============================================================
I posted some information in the last 3 months about Access Security.
Basically the text in the manual does not tell the whole story.
To get hold of the whole story get hold of the Access Security White
Paper which is stored ( I think at CICA) Nathan put it it up
somewhere cant remember exactly where. Anyway in brief the hey is
to not create the tables owned by ADMIN but rather some user.
Access 1.1 is different however I have not yet checked it for
loopholes and no one else has cpmmented on it.
Anne
Thankyou
===============================================================
=========================================================================
Date: Tue, 31 Aug 1993 13:40:52 +0200
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Slawomir Zadrozny <zadrozny@IBSPAN.WAW.PL>
Organization: Research and Academic Computer Network
Hello!
I wonder if it is known how a WHERE clause condition is evaluated. From my
experience I know that it is not done simply from left to right.
For example in the clause: (c1 AND c2 ...) OR (... AND ... AND ) OR ... OR clas
t
condition "clast" may be evaluated as a first. (I hope that my description
is not too unclear). Certainly it is a desirable effect of optimizatione done
by Access, but I would like to know what is exact order of evaluation.
Thanks for any suggestions.
Slawomir Zadrozny
Systems Research Institute
Polish Academy of Sciences
Warsaw, POLAND
=========================================================================
Date: Tue, 31 Aug 1993 08:52:53 EST
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: Nathan Brindle <NBRINDLE@INDYCMS.BITNET>
Organization: IUPUI Student Activities Office (317) 274-3931
Subject: Re: re security
In-Reply-To: Message of Tue,
31 Aug 1993 09:06:49 BST from <ALZ@IBM-B.RUTHERFOR D.AC.UK>
The White Paper is NOT on CICA--I never got around to putting it there
and will try to rectify that error today or tomorrow--but it IS available
from LISTSERV@INDYCMS by sending the command
GET SECURE TEXT
to LISTSERV@INDYCMS.BITNET or LISTSERV@INDYCMS.IUPUI.EDU.
I apologize for forgetting to put the White Paper on CICA but with the
students coming back and everything else the world is throwing at me :)
it just plain old slipped my mind.
-----------------------------------------------------BITNET: NBRINDLE@INDYCMS
Nathan C. Brindle, Administrative Specialist, Student Activities Office
Indiana University Purdue University Indianapolis
Staff Advisor, ALPHA PHI OMEGA, TAU OMICRON CHAPTER
List Administrator, STUACTS@INDYCMS, APOSEC52@INDYCMS, and ACCESS-L@INDYCMS
Internet: NBRINDLE@INDYCMS.IUPUI.EDU (preferred) or NBRINDLE@AOL.COM
Disclaimer: My opinions are my own. Indiana University can speak for itself.
------------------------------------------------------------------------------
=========================================================================
Date: Tue, 31 Aug 1993 13:17:45 -0700
Reply-To: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
Sender: Microsoft Access Database Discussion List
<ACCESS-L@INDYCMS.BITNET>
From: John von Colditz <johnvon@HALCYON.COM>
Subject: Re: Maximize the form before opening form
In-Reply-To: <199308310140.AA28361@halcyon.com> from "NCLCHAN@NTUVAX.BITNET"
at Aug 31, 93 09:19:04 am
>
> Does anyone know how to maximize the form before the form is opened ?
> Normally Macro - openform & then maximize.
>
> It is so UGLY to see the "small" form being enlarge when you execute the
macro.
> Is there a way to see the maximized form on the screen once you execute the
macr
> o ?
>
> Chor Ling
> NCLCHAN@NTUVAX.NTU.AC.SG
>
I've never tried it, but, you might be able to set the form's visible
property to false, maximize it, and then set the visible property to
true. You might also just want to store the forms with visible set to
false, open them, maximize them, set the visible property to true. You
probably want to set visible back to false when you close the form.
John